Projects are often stuck on the last same 3 tasks (needed for admin purposes) and it is clogging up all the reports we are creating - How can we exclude them?

Question

Hi all,

All of our templates (and therefore projects) are finishing with the same 3 tasks. These tasks are there for admin reasons but the teams in charge of them are always taking a very long time to complete them despite our efforts.

Because of the delays of these 3 admin tasks, the Project reports are now very busy with projects stuck on these tasks which makes them harder to read.

In a project report, how could I exclude Projects where the "up-next" tasks is one of these admin tasks. These tasks have the exact same names on all templates.

thanks,

Alexandra

Sven-iX · Answer

Hi @alexandra2

Here's how you could do this:

make a parent task for those last 3 admin tasks, eg. "Admin Tasks". It completes when all 3 children are complete.
Note the name of the task whose completion signals "project is complete", e.g. the task just before the "Admin Tasks" parent.
Ideally this is a parent task that encapsulates all tasks outside the admin tasks. Let's assume this task is called "Project Execution". It completes when all its children are complete.
Select text-mode, and add

EXISTS:a:$$EXISTSMOD=NOTEXISTS
EXISTS:a:$$OBJCODE=TASK
EXISTS:a:projectID=FIELD:ID

EXISTS:a:name=Admin Tasks
EXISTS:a:status=CPL
EXISTS:a:status_Mod=cine

EXISTS:a:name=Project Execution
EXISTS:a:status=CPL

This equates to

all projects where
we do not have tasks that (NOTEXISTS)
a task named Admin Tasks is not complete and
a task named Project Execution is complete

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded