Looking for a report that shows a list of projects and who is assigned to certain roles

[Justin_Charles]

I'm looking to create a report that shows a list of projects and who is assigned to certain roles (our copywriting roles).  For example, it would look like this:

Column 1: Project A

Column 2: Copy: Joe S, Copy Proofreader: Tim B, Copy Director: Suzi C.

Any help would be greatly appreciated!

Thanks in advance.

[skyehansen · Accepted solution]

Try either of Richard's answers in this post -- the second one should work.

https://experienceleaguecommunities.adobe.com/t5/workfront-questions/pulling-a-specific-job-role-via...