Project report showing projects NOT having a milestone task | Community
Skip to main content
_Manish_Singh
_Manish_Singh
New Participant
May 19, 2022
Solved

Project report showing projects NOT having a milestone task

  • May 19, 2022
  • 2 replies
  • 1467 views

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!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by imgrund

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

2 replies

RandyRoberts
RandyRoberts
New Participant
May 19, 2022

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

    imgrund
    imgrund
    Employee
    May 19, 2022

    This would show you all projects (that fit your project filters) that do not have the Go-Live milestone whether the milestone path is attached or not.

    If you only want ones with the milestone path attached, make sure that is one of your filters before you switch to text mode :)

    imgrund
    imgrundAccepted solution
    Employee
    May 19, 2022

    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

      Terms & ConditionsAccessibility statement

      Loading footer...