Expand my Community achievements bar.

Come join us for our Coffee Break next week on top takeaways from Adobe Summit!

Report Needed

Avatar

Level 2
All, I found the answer to my report here - "https://one.workfront.com/s/question/0D50z00006Px3tMCAR/">https://one.workfront.com/s/question/0D50z00006Px3tMCAR/ Thanks to Melinda Layten The column code is - displayname=Marketing listdelimiter=
listmethod=nested(projectUsers).lists textmode=true type=iterate valueexpression=IF(CONTAINS("Marketing",{user}.{role}.{name}),{user}.{name}) valueformat=HTML If I apply that to a column in a new project report, I can prompt the report on a user name, see all the projects that user is on and add columns for other roles to see who else is assigned to those projects. Bryan Blake Product Manager Energizer Holdings Dayton Ohio 567-998-7863 bryan.blake@spectrumbrands.com
Topics

Topics help categorize Community content and increase your ability to discover relevant content.

2 Replies

Avatar

Level 10
Hi Bryan, I'd suggest you try filtering where Role ID equals $$USER.roleID, which is among the $$USER >Wildcard Filter Variables . Regards, Doug Doug Den Hoed - AtAppStore Got Skills? Lend a hand! https://community.workfront.com/participate/unanswered-threads

Avatar

Level 2
All, I found the answer to my report here - "https://community.workfront.com/discussions/community-home/digestviewer/viewthread?GroupId=295&MessageKey=10e679df-6e62-44b2-aeea-a664b52762c0&CommunityKey=ccf3381b-a473-4ef2-9f81-4dd3244cf522&tab=digestviewer&ReturnUrl=%2fdiscussions%2fcommunity-home%2fdigestviewer%3fcommunitykey%3dccf3381b-a473-4ef2-9f81-4dd3244cf522%26tab%3ddigestviewer">https://community.workfront.com/discussions/community-home/digestviewer/viewthread?GroupId=295&Messa... Thanks to Melinda Layten The column code is - displayname=Marketing listdelimiter=
listmethod=nested(projectUsers).lists textmode=true type=iterate valueexpression=IF(CONTAINS("Marketing",{user}.{role}.{name}),{user}.{name}) valueformat=HTML If I apply that to a column in a new project report, I can prompt the report on a user name, see all the projects that user is on and add columns for other roles to see who else is assigned to those projects. Bryan Blake Product Manager Energizer Holdings Dayton Ohio 567-998-7863 bryan.blake@spectrumbrands.com