Report Needed

[BryanBl1]

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

[Doug_Den_Hoed__AtAppStore]

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

[BryanBl1]

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