Does anyone know if/how I can modify this Project report to include ALL users that are assigned to a task? It currently only displays those that are assigned as "Primary". This report displays all projects in which a user is assigned a task (the task/project will fall off the report once marked complete). However, if more than 1 user is assigned to a task within a project, that project will only display on the primary user's report. Thanks in advance!
Text Mode:
OR:1:ownerID=$$USER.ID
OR:1:ownerID_Mod=in
OR:1:statusEquatesWith=PLN CUR ONH APR
OR:1:statusEquatesWith_Mod=in
statusEquatesWith=PLN CUR ONH APR
statusEquatesWith_Mod=in
tasks:assignedToID=$$USER.ID
tasks:assignedToID_Mod=in
tasks:statusEquatesWith=CPL
tasks:statusEquatesWith_Mod=notin
Solved! Go to Solution.
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
Laura - if you're still having issues, I find that sometimes when I copy and paste codes from the internet, I need to delete the spaces between the statusEquatesWith statuses (PLN CUR ONH APR) and redo the spacing using the tab key. Just an idea! That has definitely tripped me up before. Text mode can be very humbling 😂
Hi - since it is a project report, you will need to do an EXISTS filter so you can go to the assignment object type (not just task). Here is one I have saved.
EXISTS:1:$$OBJCODE=ASSGN
EXISTS:1:assignedToID=$$USER.ID
EXISTS:1:assignedToID_Mod=in
EXISTS:1:projectID=FIELD:ID
EXISTS:1:task:status=CPL
EXISTS:1:task:status_Mod=notin
So you should end up with something like this for your final code :)
OR:1:ownerID=$$USER.ID
OR:1:ownerID_Mod=in
OR:1:statusEquatesWith=PLN CUR ONH APR
OR:1:statusEquatesWith_Mod=in
statusEquatesWith=PLN CUR ONH APR
statusEquatesWith_Mod=in
EXISTS:1:$$OBJCODE=ASSGN
EXISTS:1:assignedToID=$$USER.ID
EXISTS:1:assignedToID_Mod=in
EXISTS:1:projectID=FIELD:ID
EXISTS:1:task:statusEquatesWith=CPL
EXISTS:1:task:statusEquatesWith_Mod=notin
Thanks Anthony! I tried that EXIST filter and the report now doesn't populate any results. I'll take a deeper dive into the filter and see if I can make sense of it :)
Views
Replies
Total Likes
Laura - if you're still having issues, I find that sometimes when I copy and paste codes from the internet, I need to delete the spaces between the statusEquatesWith statuses (PLN CUR ONH APR) and redo the spacing using the tab key. Just an idea! That has definitely tripped me up before. Text mode can be very humbling 😂
Chloe - that worked!!!! Thank you SO SO much :) Laura
Views
Replies
Total Likes
Can somebody help me, I am trying to just pull all names that are assigned across all tasks within a project (but not duplicate them) and format it to look like this too in HTML
* Name 1, Role Title (div)
* Name 2, Role Title (div)
* Name 3, Role Title (div)
Views
Replies
Total Likes
Views
Likes
Replies