Finding At Risk Calculation
I am trying to find out why my sheet is marking tasks "at risk" and what the formula is. It seems to be random but I'm sure there is some rule or calculation somewhere that I'm not seeing. Can you help me find out where it might be?
Answers
-
At Risk is also called Schedule at Risk and Schedule Health. Edit the column formulas to see the formula, but I'll post them below.
At Risk =IF([Schedule Delta (%)]@row > 0.1, "Red", IF([Schedule Delta (%)]@row > 0, "Yellow", "Green")
Within your sheet you will also see Schedule Delta% and Schedule Delta (Working Days)
Schedule Delta% = =IFERROR([Schedule Delta (Working Days)]@row / Duration@row, "")
Schedule Delta (Working Days) = IFERROR(IF([End Date]@row = [Target End Date]@row, 0, IF([End Date]@row > [Target End Date]@row, NETWORKDAYS([Target End Date]@row, [End Date]@row) - 1, IF([End Date]@row < [Target End Date]@row, NETWORKDAYS([Target End Date]@row, [End Date]@row) + 1, ""))), "")
Basically it's comparing your Target End Date to the End Date, getting the number of NewWork days remaining and then dividing by Duration. Greater than 10% off is red.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!