Project Report - People Column

Hi Adina, I actually generate this as a report and then as a view as well so that users can identify quickly who's who in the project. Text mode below. description=Team Users displayname=Name link.linkproperty.0.name=ID link.linkproperty.0.valuefield=userID link.linkproperty.0.valueformat=int listdelimiter= listmethod=nested(projectUsers).lists name=ID namekey=assignment.plural stretch=25 textmode=true type=iterate valuefield=user:name valueformat=HTML width=150

Thank you, Polly. This is exactly what I needed! I only had to remove the stretch=25 line, it was giving me a pink error message. Adina ________________________________

Agreed -- thanks for sharing, Polly. As an aside, the "nested" concept that Polly used is a powerful part of Workfront's textmode feature. I encourage anyone who is striving to get the most of their reports to invest the bit of time it takes to get comfortable with it. Regards, Doug

Polly, this is great! Just so I understand the logic, the code is pulling all task assignees along with the project owner and sponsor? Or will it pull in everyone the project is shared with? I was also wondering if there's a way to modify the code to use it on other report types (e.g. issue report, task report, etc.)?

Michael, the code pulls in project owner, sponsor and task assignees, not shared users. David Cromwell had a post before on how to use nested lists. Hopefully that will help you pick data for other types of reports. https://community.workfront.com/p/fo/st/topic=62&post=726#p726

This is great! I was also looking for something like this. Thanks for sharing

Thanks, Polly!

Polly, Could you post a screen shot of the report? tks Karen

Karen, this would depend on your project filters. In one way we've used this is sort of to replace the generic Staffing/People tab on a project. See attached. The report itself does not filter to a specific project but when you put the report into a project, it just sees people within the project. I've also used this as a column view in the Project's I Own or Projects I'm On to give me a quick view as to who's who in project before getting into the project itself.

This code is great and very helpful Polly! could it be used in a Task report? Andrew Beard Sr. Associate, LeapPoint "mailto:abeard@leappoint.com" abeard@leappoint.com 203-232-4090