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
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
Any thoughts on where to begin?
Comments
-
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.
Craig
-
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.
Richardr
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 377 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 33 Webinars
- 7.3K Forum Archives