Replace Multiple Values with Multiple Values

I have a Status column which is a dropdown list. I would like a formula that checks the Status column and returns a different number for each item in the list. Any suggestions on how to do this?


"NA". "1"

"Not Started". "2"

"Priors Pending" "3"

and so forth.....

Best Answer

  • Anjanesh Vaidya
    Anjanesh Vaidya ✭✭✭✭✭
    Answer ✓

    Hi MLK,

    You can try the below formula-

    =IF(Status@row = "NA", 1, IF(Status@row = "Not Started", 2, IF(Status@row = "Priors Pending", 3, "")))

    Thank You!

    Anjanesh Vaidya


    Anjanesh Vaidya

    Smartsheet Development, Ignatiuz Software

    Did this answer help you? Show some love by marking this answer as "Insightful💡" or "Awesome❤️" and "Vote Up⬆️


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!