IF Formula
My goal is to return two potential values depending on what is selected in a multi-select column (Named: [VA...DBQ Worksheet] ).
The dropdowns are:
Service Connected Diagnosis Blank
Service Connected Diagnosis Incomplete (Rated as vs. Contention Name)
Bilateral Indicator
ICD Code
If any of the first three are selected I want the result to return as "Miss". If the ICD Code dropdown is the only thing selected, I want it to return "On Target". If nothing is selected, just return blank.
I'm thinking it would be some form of a nested IF and OR formula? My brain is stuck.
Answers
-
Hi, @Brittany Johnson , you would use a nested IF() formula. IF(NN="", "", IF( NN="ICD Code", "On Target", "Miss")).
=IF([multi-select column]@row = "", "", IF([multi-select column]@row = "ICD CODE", "On Target", "Miss"))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 302 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!