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!