Show all users assigned to a specific task, not just the primary assignee
This is very closely related to this post, which was 3 years ago and there was no solution, so seeing if there is a solution now. Text mode for column in project report to display non-Primary assignment on specific templateTask? | Adobe Experience League Community
I created a column in a project report to show who the Reviewers on the project are. I did this by returning the user assigned to any task that has “Review” in the task name. Below is my text mode code:
displayname=Reviewerslistdelimiter=<br>listmethod=nested(tasks).liststype=iteratevalueexpression=IF(CONTAINS("Review",{name}),{assignedTo},"")valueformat=HTMLIt works great, BUT only returns the primary assignee. I need it to return all users assigned to those tasks, not just the primary assignee. I’ve spent a few hours on it this morning and can’t figure it out.
I’ve also come at this from a user role angle as well. If user role does not contain X or X or X. But as the old post pointed out, people on the project aren’t always maintained and there is no defined role for Reviewer, it varies by project.
Any help is apprecieated!