3 Replies Latest reply on Jan 17, 2018 6:44 AM by Nicolas Roome

    Show team but not assignee via formula

    Scott McLaughlin

      The scenario is like this:

       

      I want to create a report via a formula that, instead of showing me Team.TestAgent; Team2; Team3.TestAgent(AgentSmith), it will simply show Team1, Team2 and Team3.  The purpose is to display a total ticket count of each teams tickets without showing the assignees.

       

      In referencing this KB link: FP12 Reporting - How to create a formula to pull the Assignee name or Team Name from the Assignee field? I noticed that it can stream line a lot of this, but using this particular formula still produces results different than what I would like

       

      Is there a better way to do this?.