Custom Column in Report - Count of People Assigned to Project | Community
Skip to main content
February 16, 2024
Question

Custom Column in Report - Count of People Assigned to Project

  • February 16, 2024
  • 1 reply
  • 611 views

I'm trying to create a project report that includes a column displaying the number of people assigned to a project. Even better, I'd love to create columns to count the number of people on a given team assigned to that project.

Is this possible? I was able to get the report to show a list of the users assigned (thanks to this thread) but I'm stuck on getting the count.

Thanks!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

skyehansen
Community Advisor
February 16, 2024

I think the closest you would get is a matrixed assignment report using DCNT.

You can read more on the DCNT function by searching in experience league like this:

https://experienceleaguecommunities.adobe.com/t5/custom/page/page-id/GlobalSearch#q=dcnt&sort=relevancy&f:@el_contenttype=[Community,Questions] 

 

Doug might also have an example of it here:

https://www.atappstore.com/App/wfpro-user-project-count/Default.aspx

 

While I've used this to do the opposite (projects a user is on), I think it also does tally up number of users on each project.