Task Report: Inactive Users with Incomplete Tasks

Question

I'm trying to come up with a report that will show me tasks that are assigned to inactive users. I've only gotten so far as creating a simple Task report that filters on:

Task >> Percent Complete is Less Than 100

And

Assigned To >> Is Active equals False

This will show all tasks in which *any* of the assigned users is inactive; which doesn't help much because it includes tasks assigned to multiple users, some of whom are still active. I've tried tweaking these filters looking for that magic trick that will yield us only those tasks in which, ideally, *all* of the assigned users are inactive; or at very least, tasks that are only assigned to one person, and that one person is inactive. Help?

Doug_Den_Hoed_AtAppStore · Accepted Answer

Hi Dave,

This is a relatively advanced question, but if you're game to do some research, rather than the 1:1 "Assigned To" primary assignee, I 'd suggest you use the 1:many Assignments object (technically, assignments:assignedTo:isActive) to check "everyone", and once you're comfortable with that, use those concepts in an EXISTS statement (well, a NOTEXISTS statement, technically) to then return only those Tasks with NO active user assigned.

Regards,

Doug

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded