Reporting all users with at least one assignment within a project

[DustinSi1]

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

[TealeMcCleaf]

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.

[DustinSi1]

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