Issue with Nested IF Formula

Heather K
Heather K ✭✭
edited 12/09/19 in Formulas and Functions

I am having trouble getting my nested if formula to work. I have the following formula:

=IF([DCO Status]@row = "Implemented", "Blue", IF(AND([Days Open]@row > 46, [Days Open]@row < 100), "Yellow", IF([Days Open]@row >= 100, "Red", IF([Days Open]@row <= 45, "Green", ""))))

It is working for all the cells except the blank ones are showing “Green” instead of a blank. Can somebody please help me?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!