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
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 443 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!