I have a task report that needs to show tasks that are assigned to anyone on "Team A" whether it's their home team or secondary team.
I am filtering by "Assigned To>Home Team ID" and "Assignment Users>Home Team ID" already (probably a little redundant).
This takes care of the user whose home team is Team A.
I need to also list tasks assigned to users whose "other teams" contain "Team A".
Racking my brain here, I'm sure the answer is easier than I think.
Can anyone help?
TX
Solved! Go to Solution.
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
Hi Randy,
If you use text mode to create an exists filter like the one below, your report will pull back all tasks that are assigned to users within a specific team regardless of whether or not it is their home team or 'other team'
EXISTS:a:$$OBJCODE=USER
EXISTS:a:ID=FIELD:assignedToID
EXISTS:a:teams:ID=123456abcdefg
Best Regards,
Rich
Hi Randy,
If you use text mode to create an exists filter like the one below, your report will pull back all tasks that are assigned to users within a specific team regardless of whether or not it is their home team or 'other team'
EXISTS:a:$$OBJCODE=USER
EXISTS:a:ID=FIELD:assignedToID
EXISTS:a:teams:ID=123456abcdefg
Best Regards,
Rich
Thank you, that worked perfectly.
Views
Replies
Total Likes
Views
Likes
Replies