Filter out Completed 'Done with my Part' Tasks in Task Report | Community
Skip to main content
Madalyn_Destafney
New Participant
May 1, 2023 9:38 PM UTC
New

Filter out Completed 'Done with my Part' Tasks in Task Report

In a task report when pulling completed tasks, it doesn't filter out tasks with multiple assignees that have completed 'their part' - it will still show for the users that have marked their part complete until everyone marks the task complete. We need a way to remove tasks in which which multiple users are assigned, but have completed their portion of the task (using a $$USER.ID filter for assignment users/assigned to).

There have been multiple questions/threads about this over the years but never an Idea - please upvote!

6 replies

New Participant
Jan 27, 2025 4:40 PM UTC

I wish I was advanced enough to use this text filter - but I don't know what parts apply to this. 😞

Translate
Madalyn_Destafney
New Participant
Jan 16, 2025 2:24 PM UTC

@alex_di no problem, glad it can help you!

Translate
If this helped you, please mark correct to help others : )
Alex_Di
Level 3
Jan 16, 2025 2:11 PM UTC

This has been talked about since Leap days.  I'm not sure why this has not been fixed.  @madalyn_destafney  thanks for the text mode, as always you hit it out of the park. 

Translate
Madalyn_Destafney
New Participant
Jun 18, 2024 4:11 PM UTC

@jpretko I ended up figuring out some text mode to filter out tasks where the $$USER.ID marked something as 'done with my part.' This is the text mode for the filter in a task report I have, it includes other things like projects only in Current status, due today or earlier, etc. so you'll need to modify as you wish.

EXISTS:1:$$OBJCODE=ASSGN
EXISTS:1:assignedToID=$$USER.ID
EXISTS:1:status=DN
EXISTS:1:status_Mod=notin
EXISTS:1:taskID=FIELD:ID
OR:1:assignmentsUsersMM:ID=$$USER.ID
OR:1:assignmentsUsersMM:ID_Mod=in
OR:1:personal=true
OR:1:personal_Mod=eq
OR:1:plannedCompletionDate=$$TODAY
OR:1:plannedCompletionDate_Mod=lt
OR:2:isComplete=false
OR:2:isComplete_Mod=eq
OR:2:numberOfChildren=0
OR:2:numberOfChildren_Mod=eq
OR:2:plannedCompletionDate=$$TODAY
OR:2:plannedCompletionDate_Mod=lte
OR:2:project:statusEquatesWith=CUR
OR:2:project:statusEquatesWith_Mod=in
OR:2:teamID=$$USER.teamIDs
OR:2:teamID_Mod=in
assignmentsUsersMM:ID=$$USER.ID
assignmentsUsersMM:ID_Mod=in
isComplete=false
isComplete_Mod=eq
numberOfChildren=0
numberOfChildren_Mod=eq
plannedCompletionDate=$$TODAY
plannedCompletionDate_Mod=lte
project:statusEquatesWith=CUR
project:statusEquatesWith_Mod=in

Translate
If this helped you, please mark correct to help others : )
JPretko
New Participant
Jun 18, 2024 3:28 PM UTC

@madalyn_destafney Did you ever find any resolution to this issue? We are curious about the same thing.

Translate
Level 2
Jul 31, 2023 4:20 PM UTC

This would 100% be super helpful as we have a copywriter, production designer and creative designer on nearly every task!

Translate