Project Health formula Help needed

=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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!