Solved
Report on all users assigned in a project?
I'm trying to build a project report that includes a column listing all project assignments. I've yet to find the right field to pull. Is it possible in a more creative way?
svetlanasilinaAccepted solution
Employee
Aug 9, 2021 2:09 PM UTC
Hi Lyndsy! If I'm reading your question correctly, you'd like to run a project report and have a column that lists the project team for each project. This would add all users that are associated with a project and listed under the People area of the project. Is that correct?
You could follow these steps to do that using text mode:
- Create a Project report with the required filters, views and groupings
- While adding the report, add a column to the View, select the column by clicking on the column header and switch to text mode
- Paste the following code into the text mode and Save the report
description=Team Users
displayname=Project Team
listdelimiter=<div>
listmethod=nested(projectUsers).lists
textmode=true
type=iterate
valueexpression=CONCAT("* ",{user}.{name})
valueformat=HTML
NOTE: You can remove the * that shows up as a bullet for each name by removing the "* ", part of the code.
I hope that this helps to resolve your obstacle!