Project Health Calculation

Please can you assist.

I am currently using the SS Standard template Schedule Health Formula :

Project Heath Formula

=IF([Schedule Delta (%)]@row > 0.1, "Red", IF([Schedule Delta (%)]@row > 0, "Yellow", "Green"))


My issue - Milestones which should not be are showing green because the Duration is Zero (see schedule formulas below which use duration)


How can I adapt the formula to revert to the parent health where duration is Zero ?


Schedule Delta Formula :

=IFERROR([Schedule Delta (Working Days)]@row / Duration@row, "")

Schedule Delta (Working Days) :

=IFERROR(IF([End Date]@row = [Baseline End Date]@row, 0, IF([End Date]@row > [Baseline End Date]@row, NETWORKDAYS([Baseline End Date]@row, [End Date]@row) - 1, IF([End Date]@row < [Baseline End Date]@row, NETWORKDAYS([Baseline End Date]@row, [End Date]@row) + 1, ""))), "")



Many Thanks

Lee

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!