I have a task report that is pulling in any tasks assigned to 5 different teams. I want to make it only display the tasks (from these 5 teams) that the viewer also belongs to that team. I was thinking this would involve an Exists statement but the more I stare at the Exist formula I cannot determine how to apply my conditions.
I can't just use the wildcard for User Team IDs since they may belong to more teams than these 5 I am reporting on.
Anyone know how to approach this?
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
You would probably have 5 sets of "or" statements for each team in combination to the assigned to $$USER.ID.
Assigned to $$USER.ID
Team ID = XYZ
OR
Assigned to $$USER.ID
Team ID = ABC, etc.
Views
Replies
Total Likes
It's actually not assigned to the user though, just to a team they are part of.
So what I essentially need to accomplish is
Task > Team ID = $$USER.teamIDs
and
Task > Team ID = Team XYZ
OR
Task > Team ID = $$USER.teamIDs
and
Task > Team ID = Team ABC
But I can't duplicate the same field within a section so am looking at a different way to get this same filter.
Views
Replies
Total Likes