How are you calculating or showing slippage in a complex project? | Community
Skip to main content
SuzannaHathaway
SuzannaHathaway
New Member
June 26, 2025
Solved

How are you calculating or showing slippage in a complex project?

  • June 26, 2025
  • 2 replies
  • 334 views

I am trying to use Baselines - but I am not seeing how I would show that a project has slipped a month from its start.  Does anyone have a process they are using to calculate slippage in a project or a series of projects?  Thanks in advance for any guidance you can provide!

 

Sue

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 Sven-iX

One way is to "save" initial planned dates as "set-once" calculated fields, and then show slippage in a second calculated field. 

IF(ISBLANK({DE:myOrigPlannedCompletion})&&{status}="CUR", {plannedCompletionDate}, {DE:myOrigPlannedCompletion})

The above will set the field ONLY if it's still empty, and the status is CUR. 

You can then create a second calc field to show the DATEDIFF

2 replies

Sven-iX
Community Advisor
Sven-iXCommunity AdvisorAccepted solution
Community Advisor
June 26, 2025

One way is to "save" initial planned dates as "set-once" calculated fields, and then show slippage in a second calculated field. 

IF(ISBLANK({DE:myOrigPlannedCompletion})&&{status}="CUR", {plannedCompletionDate}, {DE:myOrigPlannedCompletion})

The above will set the field ONLY if it's still empty, and the status is CUR. 

You can then create a second calc field to show the DATEDIFF

    kautuk_sahni
    Community Manager
    kautuk_sahniCommunity Manager
    Community Manager
    July 29, 2025

    @suzannahathaway Just checking in — were you able to resolve your issue? We’d love to hear how things worked out. If the suggestions above helped, marking a response as correct can guide others with similar questions. And if you found another solution, feel free to share it — your insights could really benefit the community. Thanks again for being part of the conversation!

    Kautuk Sahni
    Terms & ConditionsAccessibility statement

    Loading footer...