Health Formula

leezee

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

Paul Newcome

Try this...

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

leezee

Awesome! Thank you @Paul Newcome

Paul Newcome

Try this...

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

leezee

Awesome! Thank you @Paul Newcome

Paul Newcome

Happy to help. 👍️

Maria Ashley

I have the same issue and just tried using the updated formula in the Schedule Health column, however it does not seem like it fixed the issue. Were there any further tweaks that you needed to make in other parts of the project plan sheet? @leezee @Paul Newcome