Health formula
I have a Percentage Complete and a Expected Percentage Complete column that I use for my Health calculation.
The Percentage Complete is manual, based on actual completion. The Expected Percent Complete is a formula based on how much shoudl be completed based on Start and End Dates: =IF(Status@row = "Pending", 0, IFERROR(AVG(CHILDREN()), IF([End Date]@row <= TODAY(), 1, IF([Start Date]@row >= TODAY(), 0, IF([Start Date]@row <= TODAY(), NETWORKDAYS([Start Date]@row, TODAY()), 0) / NETWORKDAYS([Start Date]@row, [End Date]@row)))))
My Health formula compares Percentage Complete and Expected Percentage Complete to calculate Health: =IF([% Complete]@row = 1, "Yes", IF([Expected % Complete]@row = 0, "Yes", IF([Expected % Complete]@row < [% Complete]@row, "Yes", IF([Expected % Complete]@row < [% Complete]@row + 1, "Hold", "No"))))
I want to change the parameters for "Hold" so that if Expected Percent Complete is 10% or greater than Percent Complete, "Hold"
Any ideas?
Best Answer

That would look more like the portions in bold:
=IF([% Complete]@row = 1, "Yes", IF([Expected % Complete]@row = 0, "Yes", IF([Expected % Complete]@row < [% Complete]@row, "Yes", IF([Expected % Complete]@row >= [% Complete]@row + 0.10, "Hold", "No"))))
Answers

That would look more like the portions in bold:
=IF([% Complete]@row = 1, "Yes", IF([Expected % Complete]@row = 0, "Yes", IF([Expected % Complete]@row < [% Complete]@row, "Yes", IF([Expected % Complete]@row >= [% Complete]@row + 0.10, "Hold", "No"))))

That worked.. I did need to make one change:
=IF([% Complete]@row = 1, "Yes", IF([Expected % Complete]@row = 0, "Yes", IF([Expected % Complete]@row < [% Complete]@row, "Yes", IF([Expected % Complete]@row <
=
[% Complete]@row +0.10
, "Hold", "No"))))Thanks!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.2K Get Help
 320 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 276 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!