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

Kristin McClinton

=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")))

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