Formula for Schedule Health with multiple criteria
I am working on a formula for Schedule Health:
1. when Status is failed or on-hold or cancelled or when Schedule is delayed => RED
2. when Status is Pass or Complete or In-progress or when Schedule is on-track => GREEN
3. No information at STATUS column, no symbol
How should I write the formula at Schedule Health?
Any assistance is appreciated.
Help Article Resources
Check out the Formula Handbook template!