Expand my Community achievements bar.

Reporting all users with at least one assignment within a project

Avatar

Level 2
Hello, I am seeking to create a project report that includes a column for all users who were assigned at least one task within that project. I have successfully pulled the correct data using this expression: displayname=Team Members listdelimiter= listmethod=nested(tasks).lists textmode=true type=iterate valueexpression=IF(ISBLANK({assignedTo}), "", {assignedTo}.{name}) valuefield=assignedTo valueformat=HTML The only issue I have now is that anyone with two or more tasks has their name repeated for every task they are assigned to. Can anyone advise how I could modify the custom data to exclude duplicates and only show each name once? Thanks! Dustin Silbereisen Senior Digital Strategist Novant Health
Topics

Topics help categorize Community content and increase your ability to discover relevant content.

2 Replies

Avatar

Level 7
Hi Dustin - If you change the nested list like this... displayname=All Users listdelimiter=
listmethod=nested(projectUsers).lists textmode=true type=iterate valuefield=user:name valueformat=HTML You'll only see the users name once in the returned values. Hope this helps, Teale Teale McCleaf Google Inc.

Avatar

Level 2
Perfect solution. Thank you very much! Dustin Silbereisen Novant Health