Formula in Symbols column using IF... need help!

edited 08/27/23 in Formulas and Functions

I'm attempting my first IF formula and am needing some help. Need to produce RYG in the symbols column based on a column we use for % Complete. Keep coming up with an error. What am I doing wrong?

=IF([Complete]@row = 0), "Red", IF([Complete]@row = .01 - .99), "Yellow", IF([Complete]@row = 1), "Green")))


  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭

    Hey @cmrapp

    You have misplaced parentheses. You are closing off the IF statements too early.

    Try this

    =IF(Complete@row = 0, "Red", IF(Complete@row = 1, "Green", "Yellow"))

    With only 3 colors you only have to define two criteria. The third color will be anything leftover that is not defined in the first two criteria.

    Does this work for you?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!