Formula

Options

Trying to make a conditional helper column based on 3 color options. There is an issue with the IF red = 3 part of the formula

=IF(Status@row = "Green", "5", (IF(Status@row = "Yellow", "4")), "3")

Answers

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Options

    Hi @Jennifer Flanagan

    Hope you are fine, please try the following formula.

    =IF(Status@row = "Green", 5, IF(Status@row = "yellow", 4, 3))

    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!