reporting hours logged on tasks by non-assignees

[KristenS_WF]

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?

[skyehansen]

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]

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!

[kautuk_sahni]

@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!