Display tasks with multiple Assignees for Any of their Managers | Community
Skip to main content
Level 2
Mar 11, 2020 5:00 PM UTC
Question

Display tasks with multiple Assignees for Any of their Managers

Hello, I want to create a report so that managers with direct reports can see all the tasks/projects their staff is assigned to...So I created a filter: Manager ID equals $$.User.ID however, this doesn't work when there are multiple assignees to a task...because the report only comes back for the Manager of the person who owns the task. If user A and B are both assginees to a task, I would like to have this report works for both of their managers regardless the owner of the tasks. Thanks! Michelle Michelle Speck Royal Neighbors of America
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

Level 2
Mar 11, 2020 6:02 PM UTC
Thank you, Anthony for the very valuable information. It works! I will pass on the ppt presentation to my team for reference. Michelle Speck Royal Neighbors of America
Translate
imgrund
Employee
Mar 11, 2020 5:16 PM UTC
Hi Michelle - I highly recommend using an Assignment report when working with managers. An assignment report will create a separate line item for every assignee on a task or issue so you can create a fantastic report for a manager that not only groups all the tasks by assignee (which they love), but also includes issues they might be assigned. In 2018, Kathy and I did a presentation at LEAP about reporting and the report I'm talking about was featured. Here are the slides so you can replicate it on your side. The only difference will be that for Assigned To Home Group ID, you will use Assigned To Manager ID equals $$USER.ID :) Let me know if you run into any issues. Anthony Imgrund FCB
Translate