reporting hours logged on tasks by non-assignees | Adobe Higher Education
Skip to main content
KristenS_WF
KristenS_WF
Level 6
June 12, 2025
質問

reporting hours logged on tasks by non-assignees

  • June 12, 2025
  • 2 の返信
  • 488 ビュー

My manager exported some utilization data from Planner.  The actual hours for a particular user seemed low, and we realized it was because this user had logged hours for tasks to which she had not been assigned.  We're trying to determine how widespread this issue might be.

I built an hours report, and I first tried filtering where the owner ID does not equal the assigned to ID

ownerID=FIELD:task:assignedToID ownerID_Mod=ne

This did pull records we're looking for, but it also pulled records where the person logging the hours was an assignee on the task but not the primary assignee.

Is there a way to filter out the latter records?  I tried experimenting with different variations of my filter (including using assignmentsListString and assignmentsUsersMM), all without success.  Does anyone know how to filter on hours logged by non-assignees?

2 の返信

skyehansen
Community Advisor
skyehansenCommunity Advisor
June 12, 2025

If we keep going with your original thought, it feels like it would need to be an exists filter. Something like maybe "no assignment exists where the assigned to ID = Hour's owner ID"? Maybe?

 

EXISTS:a:$$EXISTSMOD=NOTEXISTS

EXISTS:a:$$OBJCODE=ASSGN

EXISTS:a:assignedToID=FIELD:ownerID

 

You'd have to test it. I'm not entirely sure if my logic is right here.

    KristenS_WF
    KristenS_WF作成者
    Level 6
    June 13, 2025

    It was a good thought, but it's not given me the correct result.  Maybe because assignments are a collection in the task object?  Not sure.

    I guess I can export my existing report to Excel and use a formula to filter out the entries where the owner is among the assignees.

    Thanks for the suggestion!

      KristenS_WF
      KristenS_WF作成者
      Level 6
      November 5, 2025

      Ahhhh... finally got it by finding an old post with a reply by @nicholevargas.

      https://experienceleaguecommunities.adobe.com/t5/workfront-questions/report-to-know-resources-logging-time-to-unassigned-tasks/m-p/611693/highlight/true#M55385

      Here's Nichole's code:

      EXISTS:1:$$EXISTSMOD=NOTEXISTS EXISTS:1:$$OBJCODE=ASSGN EXISTS:1:assignedToID=FIELD:ownerID EXISTS:1:taskID=FIELD:taskID

      Thanks, @nicholevargas--I kept getting the error triangle with everything else I tried!

        kautuk_sahni
        Community Manager
        kautuk_sahniCommunity Manager
        Community Manager
        July 29, 2025

        @kristens_wf 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 really benefit the community. Thanks again for being part of the conversation!

        Kautuk Sahni
        契約条件Accessibility statement

        Loading footer...