Struggling with an IF formula I feel should be simple.


What I am trying to do is this:

If the Status is Satisfied, Health is Green

If the Status is Concerned, Health is Yellow

If the Status is At Risk, Health is Red

Tried: =IF(Status = "Satisfied", "Green", IF(Status = "Concerned", "Yellow", IF(Status = "At Risk", "Red")))


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!