Task Report Filter - Compare Assignments to Project Sponsor | Community
Skip to main content
KellieGardner
Community Advisor
KellieGardnerCommunity Advisor
Community Advisor
August 20, 2025
Solved

Task Report Filter - Compare Assignments to Project Sponsor

  • August 20, 2025
  • 3 replies
  • 625 views

I'm trying to find a way to run a task report that will show me when a Project Sponsor is not one of the users assigned to the task in that project.

 

These do not work

assignmentsUsersMM:ID=FIELD:projectSponsorID
assignmentsUsersMM:ID_Mod=notin


assignmentsUsersMM:ID=FIELD:project:sponsorID
assignmentsUsersMM:ID_Mod=notin

 

 

I'm not sure if it's possible since the Assignments is a collection of data on the task, and ultimately, it's too many jumps to get to the project sponsor ID?

 

 

Any suggestions?

 

    Best answer by Sven-iX

    Hi @kelliegardner 

    try this: it's an assignment report. It assumes you're interested in a particular task on the project (hence the name check).
    The only downside is that it'll show all assignments without the sponsor - so you'd have to group by project.  

    assignedToID_Mod=notblank EXISTS:2:$$EXISTSMOD=NOTEXISTS EXISTS:2:$$OBJCODE=PROJ EXISTS:2:ID=FIELD:projectID EXISTS:2:sponsorID=FIELD:assignedToID task:name=should have sponsor task:name_Mod=cicontains taskID_Mod=notblank

     Also - If you're looking for tasks where the sponsor IS assigned, this works fine:

    project:sponsorID=FIELD:assignments:assignedToID project:sponsorID_Mod=eq

     

    But the inverse doesn't work as expected

    project:sponsorID=FIELD:assignments:assignedToID project:sponsorID_Mod=ne

     

    In general I've found the not-in capabilities lacking 😞 I really think the simplest is the hidden calculated field, then you can do a simple compare at the task level and even colorize the row based on that.

    3 replies

    JustinRenteria2
    JustinRenteria2
    Level 6
    August 21, 2025

    Hmm I havent tested this but perhaps you can create a calculated field on the Task custom form that references the project:sponsorID field. I'm still iffy on whether the Assignment "collection" will allow this comparison though.  

      Sven-iX
      Community Advisor
      Sven-iXCommunity Advisor
      Community Advisor
      August 27, 2025

      HI @kelliegardner 
      See if this works for your usecase

      EXISTS:A:$$EXISTSMOD=NOTEXISTS EXISTS:A:$$OBJCODE=PROJ EXISTS:A:ID=FIELD:projectID EXISTS:A:sponsorID=FIELD:assignedToID

      In my test is seems to work, pulling up ONLY tasks to which the sponsor is NOT assigned. 

        MoniqueEvans
        Community Advisor
        MoniqueEvansCommunity Advisor
        Community Advisor
        August 27, 2025

        I was thinking this route as well, but instead of using the PROJ object code, try the project user (PRTU) object code; however that would assume the user is only listed on that task and no where else.

         

        Throwing spaghetti on the wall...

        What about assignmentsListString instead of assignedToID?

          kautuk_sahni
          Community Manager
          kautuk_sahniCommunity Manager
          Community Manager
          August 29, 2025

          @kelliegardner Just checking in. Were you able to resolve your issue? We’d love to hear how things worked out. If the suggestions above helped, marking a response as correct can guide others with similar questions. And if you found another solution, feel free to share it — your insights could benefit the community. Thanks again for being part of the conversation!

          Kautuk Sahni
          Terms & ConditionsAccessibility statement

          Loading footer...