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
-
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
-
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⬆️
-
@Anjanesh Vaidya Perfect. Thanks!!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!