Nested If SmartSheet Formula For Symbols (R, G, Y)

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

i.e.

=IF(data < number, "TRUE Symbol Text", (IF(data = number, "TRUE Symbol Text", "FALSE Symbol Text")))

Thank You,

Kristin McClinton

Comments

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭

    Hey @Kristin McClinton

    I moved a few parentheses around.

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

    cheers

    Kelly