Project Health formula Help needed

natasha ross

=IF([Schedule Delta (%)]@row > 0.1, "Red", IF([Schedule Delta (%)]@row > 0, "Yellow", IF(TODAY(10) >= [End Date]@row, IF([% Complete]@row < 0.75, "Yellow", "Green"))))

These is what I want the rules around the health to be but when i enter the above formula the cell is blank some of the time.

If scheduled end date is changed to 10% past original end date – RED

If scheduled end date is changed to 1-9% past original end date – yellow

If end date is less than 10 days from today and less than 75% complete - yellow

Neither of the above is true = Green

Paul Newcome

Try this...

=IF(AND([End Date]@row <= TODAY(10), [% Complete]@row < 0.75), "Yellow", IF([Schedule Delta (%)]@row > 0.1, "Red", IF([Schedule Delta (%)]@row > 0, "Yellow", "Green")))