# Health formula

Options
✭✭✭

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?

• ✭✭✭✭✭✭
Options

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"))))

• ✭✭✭✭✭✭
Options

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"))))

• ✭✭✭
Options

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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!