Nested If formula for RYG


Good morning,

I'm having an issue with the following formula. The red and green come out, but the yellow comes back blank. Any assistance would be appreciated.

=IF([% Complete]@row < 0.7, "Red", IF([% Complete]@row <= 0.07 - 1, "Yellow", IF([% Complete]@row = 1, "Green")))


Best Answer

  • Laurie Bearden
    Laurie Bearden ✭✭✭
    Answer ✓

    I figured out the answer...I changed it to say

    =IF([% Complete]@row < 0.7, "Red", IF([% Complete]@row = 1, "Green", "Yellow"))

    I tried to find a way to delete my question, but maybe this will help someone else in the future 😉


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!