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.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!