Task Assignment Project Report | Community
Skip to main content
K
Kasey-Gagne
Level 5
December 15, 2023
Solved

Task Assignment Project Report

  • December 15, 2023
  • 2 replies
  • 900 views

I am trying to build a report that pulls the number of projects a user was assigned to rather than the number of individual tasks within a project. I've tried a project, task, and assignment report but I cannot seem to get it to function correctly. 

 

Example: A chart that shows how many projects each user on Designer Team was assigned to this year -- NOT how many tasks they completed.

 

Has anyone successfully built something similar or is this not possible to do? Thanks in advance!

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

Hi, 

You could try it with a Project report and include the following text mode filter:

 

statusEquatesWith=CUR,PLN
statusEquatesWith_Mod=in
EXISTS:a:$$EXISTSMOD=EXISTS
EXISTS:a:$$OBJCODE=TASK
EXISTS:a:assignments:assignedToID=$$USER.ID
EXISTS:a:assignments:assignedToID_Mod=eq
EXISTS:a:projectID=FIELD:ID
EXISTS:a:actualCompletionDate_Mod=isnull

 

You could adjust the separate parts to get exactly what you want, but maybe you can use this as a start.

2 replies

KellieGardner
Community Advisor
KellieGardnerCommunity Advisor
Community Advisor
December 15, 2023

@doug_den_hoed__atappstore - has a solution on his website you can deploy for this (and it's Free!)

 

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

This Package provides a Dashboard that shows the number of Projects per User in grid mode, and the number of Assignments per User in Chart mode.

 

 

F
FemkeCrAccepted solution
Level 4
December 18, 2023

Hi, 

You could try it with a Project report and include the following text mode filter:

 

statusEquatesWith=CUR,PLN
statusEquatesWith_Mod=in
EXISTS:a:$$EXISTSMOD=EXISTS
EXISTS:a:$$OBJCODE=TASK
EXISTS:a:assignments:assignedToID=$$USER.ID
EXISTS:a:assignments:assignedToID_Mod=eq
EXISTS:a:projectID=FIELD:ID
EXISTS:a:actualCompletionDate_Mod=isnull

 

You could adjust the separate parts to get exactly what you want, but maybe you can use this as a start.

K
Kasey-GagneAuthor
Level 5
February 9, 2024

This was a perfect start to getting me what I needed, thank you so much!!

L
ljorr16
Level 3
June 26, 2025

Hi! I know this is from a while back, but I'm trying to get exactly this chart. Do you mind sharing the text mode that got you there? That would be SO helpful. Thanks!

Terms & ConditionsAccessibility statement

Loading footer...