People assigned to a project | Community
Skip to main content
April 2, 2019
Question

People assigned to a project

  • April 2, 2019
  • 12 replies
  • 2142 views
I want to create a report that can tell me every "project" a person is on. The only one I'm able to do now lists every "task" the person is assigned to on the "project" but not the project itself. We just want to see how many "projects" a person is assigned to (not their tasks). Is there a way to do this? If so, can you please share the report filters. Thank you! Diana Diana Warren True Value Company
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

12 replies

Level 8
April 4, 2019
Hi Jessie, I know we're looking at revamping the reporting system, but I do not have an ETA on when that will happen. That said, you could book some time with our consulting team to explore options, or if you're comfortable with text mode, you should be able to reference a collections for the task assignments. Here's a help article that discusses how to use collections in reports: https://support.workfront.com/hc/en-us/articles/115000586214-Referencing-Collections-in-a-Report And I believe the field you'd use on the task level would be assignmentsListString, but I'm also not a reporting master.. I'm around a 6/10 here, which is why I recommend our consulting team. You can contact your Account Executive for a quote for a small block of hours. Thanks and good luck! Dustin Martin Assigned Support Engineer Workfront
DianaWaAuthor
April 4, 2019
Hi, I just want to let everyone know that the filters Jessie provided are working fine for me. I am on at least 3 tasks on 200 jobs that are "current" and when I run this report it only lists the "project" once, not 3 times even though I have 3 tasks on a project. I ran these reports for 10 other team members and the job comes up only once even though they are on more than 1 task within the project. Thanks, Diana Diana Warren True Value Company