Project report showing projects NOT having a milestone task

Question

Hi Workfront Community,

I'm looking for a solution that might be a little bit complex but your suggestions to achieve this are welcome. To be honest we are struggling to get something which looks very simple.

So.. we want to track projects that do NOT have a milestone linked on any of its tasks list. Example: Let's say we have Initiation, Design, Delivery and Go-Live milestones on a milestone path. I'm trying to identify projects that do not have "Go-Live" linked on its tasks. We want to make adding "Go-Live" as a mandate for our PMs to produce KPIs.

I believe we'll have to use 'collections' here because referencing does not work down the object hierarchy.

Thanks!

imgrund · Accepted Answer

Hi - once you get the Milestone ID for Go-Live, you can use the below. Make sure you do all the regular project filters you want first. Then you switch to text mode and paste this underneath everything.

EXISTS:1:$$EXISTSMOD=NOTEXISTS

EXISTS:1:$$OBJCODE=TASK

EXISTS:1:milestoneID=c018bbf4237645cae053a7656a0a9384

EXISTS:1:projectID=FIELD:ID

*NOTE: Change the bold ID for your milestone ID

RandyRoberts · Answer

So, the project would have a milestone path but no tasks would be marked with the "Go-Live" milestone?

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded