Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Predicting a bad situation

edited 12/09/19 in Archived 2017 Posts

I have projects with 3 milestones, call them A, B, C

C is dependent on B which is dependent on A.

C is a critical completion date.

If either A or B is late, C is automatically late and that is very bad.

If A or B is late by X number of days, C automatically is now going to be late by that same number of days.

I'm looking to design a report or alert that says -

A has not been completed. It should have been completed X days ago, the new completion date for C will now be Y. (same thing for milestone B)

Any thoughts on where to begin?




  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭
    edited 10/31/17

    You'll likely want to:

    1. enable Dependencies in the Project Settings.

    2. Create copies of the start / end date columns after the schedule is agreed upon. That's your baseline (last approved schedule)

    3. Create columns to check variance between actual dates and baseline dates. 

    4. Build alerts and formulas and conditional highlighting based on variances.

    Formulas will be something like this (not actual code)


    if ( MS A not complete   AND MS A end date in the past ) then 

    days late is MS A end date - today()

    you'll want to do A and B separately, because they do not have a precedence over each other and you want to know about both of them, not one or the other.

    It isn't as complicated as it may seem but it depends a lot on your particular PM style (or lack of same). If you'd like some PM support or training, reach out to Richard at richardr@smarterbusinessprocesses.com) He's in the UK and we work together.


  • Richard Rymill SBP
    Richard Rymill SBP ✭✭✭✭✭✭

    Hi JS

    a very sensible requirement to want and happy to help you develop this further if needed? 

    Nicely explained Craig... as usual, a great solution.  

    Just let us know if you need any help. 




This discussion has been closed.