I need a formula which gives "symbols" (Red, Yellow or Green)

Options
Eric Laitenberger
Eric Laitenberger ✭✭✭✭✭
edited 02/13/23 in Formulas and Functions

Hello,


I need a formula which gives "symbols" (Red, Yellow or Green)

If < 15 : green If its >14 and < 21 Yellow and if 21 Red


Answers

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭
    Options

    Hi @Eric Laitenberger ,

    I think this is what you're after:

    =IF(Value@row < 15, "Green", IF(Value@row < 21, "Yellow", "Red"))

    Output:

    Adjust numbers and column reference instead of "Value" as required.

    Hope this helps, but if you've any questions etc. then just post! 😊

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!