Task Report - show tasks that are assigned to anyone on a specific team even if it's not their home team

[RandyRoberts]

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

[Richard_Le_ · Accepted solution]

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

[RandyRoberts]

Thank you, that worked perfectly.