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?

STATUS. RETURNED VALUE

"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

    Thanks,

    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⬆️

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!