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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!