Reporting Tasks with Multiple Assignees

Forum|Forum|8 years ago
February 24, 2018
2 replies
1319 views

Hi, I am looking for a way to report the names of all assignees on a task when there is more than one person assigned. The intent is to show the total number of tasks each person is assigned even if there are multiple assignees to a task. For example: Task 1: Assigned to Person A only Task 2: Assigned to Person B only Task 3: Assigned to Persons A and B Task 4: Assigned to Person C only Report to show: Person A has two tasks Person B has two tasks Person C has one task If anyone has any guidance, it would be greatly appreciated! Thank you!! Theresa Larocque Suncor Energy

T

TheresaLaAuthor

New Participant

Hi Doug, That is exactly what I've been attempting to create! Thank you so much for the information, instructions and screen shots - very easy to follow and replicate. Theresa Larocque Suncor Energy

Doug_Den_Hoed__AtAppStore

New Participant

Hi Theresa, I wasn't sure on this one, so as attached, I modeled your example data, then used an Assignments report grouped by Assigned To Name in order to get the correct total number of assignments by person, as shown parenthetically at the end of each User's grouping. Regards, Doug Doug Den Hoed - AtAppStore Got Skills? Lend a hand! https://community.workfront.com/participate/unanswered-threads