Formula

Jennifer Flanagan
Jennifer Flanagan ✭✭
in Formulas and Functions

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

· Share on FacebookShare on Twitter

Answers

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭

    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"

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!