Project Report - People Column

Hi Andrew, I don't think you can call a project's collection within a task report but maybe somebody else have tried it. Cheers.

Yes you can. Inside the name of the collection you do project. and then the rest is the same. So for a projectUsers list on a task report it would be listmethod=nested(project.projectUsers).lists no changes on the valueexpression or anything else. Example that displays the name of the Art Director(s) on a project in a task report: displayname=Art Director listdelimiter= listmethod=nested(project.projectUsers).lists textmode=true type=iterate valueexpression=IF(CONTAINS("Art Director",{user}.{role}.{name}),{user}.{name}) valueformat=HTML -- Melinda Layten, Senior Consultant Work Management Improvement CapabilitySource Phone: (484) 505-6855 site: www.capabilitysource.com email: melinda.layten@capabilitysource.com - we simplify your work so you can run your business -

I never thought of even trying " project.projectUser"! I will now have to think how I can apply objcode.listcode on other reports. Polly Co

Very neat. Could this be modified to search for the users secondary job roles and not just their primary? I've tried changing .role to .roles and other variations but it returns no reseults . Andrew Beard - LeapPoint Senior Associate LeapPoint Herndon VA

I don't think you can traverse 2 nested lists for the user and all of their job roles. There is a ProjectUserRole object that you can use to see who is assigned to each role in the project. So if a user is assigned to one of their secondary roles it should appear. So there are 3 related collections: ProjectUsers - The team on the projects Roles - The roles that are on the project ProjectUserRole - The users assigned to roles on the project Unassigned roles are not in the ProjectUserRole list. If a user is assigned without a previous role their primary role is put on the list. Here's an example of a shared column that traverses several of the objects: Looks to see if role is on a project and who is filling the role, replace Copywriter with the name of the role. Blank is not on the project, Yes means it's on the project. Yes blank is unassigned, Yes name is assigned. column.3.valueexpression=IF(CONTAINS("Copywriter",{name}),"Yes ","") column.3.type=iterate column.3.listmethod=nested(roles).lists column.3.sharecol=true column.3.listdelimiter=& z w j ; column.3.textmode=true column.3.valueformat=HTML column.3.displayname=Copywriter column.4.valueformat=HTML column.4.displayname=Spacer column.4.textmode=true column.4.width=1 column.4.sharecol=true column.4.valuefield=< b r > column.5.valueformat=HTML column.5.type=iterate column.5.listmethod=nested(projectUserRoles).lists column.5.listdelimiter=& z w j ; column.5.textmode=true column.5.valueexpression=IF(CONTAINS("Copywriter",{role}.{name}),CONCAT({user}.{name}," ")) Spaces added to < b r > and & z w j ; to prevent them being encoded. Remove spaces if copying. -- Melinda Layten, Senior Consultant Work Management Improvement CapabilitySource Phone: (484) 505-6855 site: www.capabilitysource.com email: melinda.layten@capabilitysource.com - we simplify your work so you can run your business -

First off, I want to say this thread is fantastic! I've been hoping to find a way to set up columns like these for ages (only recently have I begun to delve into the wonderful world of text mode). I think I've learned a lot just reading through here! I tried applying the role-specific code to my own reports, and it appears to be pulling the data correctly, but I'm having a bit of an issue with the formatting... Does anyone have any pointers for what might be causing the list of users to be spread out like it is in the screenshot below? Here is the code I used (it was shared earlier in this thread, but I want to repost just to be clear on exactly what I've used): displayname=DPA listdelimiter=< b r > listmethod=nested(project.projectUsers).lists textmode=true type=iterate valueexpression=IF(CONTAINS("DPA - Digital Production Artist",{user}.{role}.{name}),{user}.{name}) valueformat=HTML Also, I understand this is pulling from the Staffing tab in the project, but is there any way to have it pull from the assigned tasks on the project instead? For example, in the top line in my screenshot, Melissa is the only DPA that's actually working on the project, but it's listing Rick and Kevin because they are on the People list of the Staffing tab, and they are also DPAs. Is the only way to sort them out of the results to remove them from the Staffing list? Thanks! Mike Perez Tailored Brands

Hi Mike, I suspect the extra space is occurring because you've chosen < b r > as your delimiter (creating a new line), and then hide or show the name of a person based on your IF statement. If you instead use  (non breaking space), it will collapse all of the rows...but run each user's name into each other. You might be able to CONCAT "< b r >" at the end of each of the names that are to appear visually to force an extra row, but I've not tested that, and the browsers might not honor it. If you'd rather search for a particular Task to drive the list of users, same concept, but iterating tasks, rather than projectUsers, looking at each Task's primary role (name) for the role in question, and where (only then) there's a match, showing the Task's primary assigned user, like this: listdelimiter= listmethod=nested(tasks).lists textmode=true type=iterate valueexpression=IF(CONTAINS("DPA - Digital Production Artist",{role}.{name}),{assignedTo}.{name}) valueformat=HTML Regards, Doug Doug Den Hoed - AtAppStore Got Skills? Lend a hand! https://community.workfront.com/participate/unanswered-threads

My favorite list delimiter, by far, is the