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

Question

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 Answer

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

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded