How to Build Nested ISBLANK or NOT ISBLANK Formula?

mistone
mistone โœญโœญโœญโœญ
Screenshot 2023-04-05 083742.jpg

I want to build a row formula in the Itinerary helper column that evaluates a the series cells in 7 adjacent columns (Camping & Hiking thru Wilderness Medicine Classes).

For example: When the formula works - Itinerary Helper column on Wilderness Medicine row = Wilderness First Aid.

In this instance only 1 of the 7 cells in each row will have data in it. The data is generated through a form our customers are asked to complete. The form has logic in it so the customers will select 1 of 7 options and then pick an item from the a dropdown menu. Here is the form if that is helpful.ย 

https://app.smartsheet.com/b/form/4793a64b08b34927977b111dd5133347

I've been experimenting if nested IF(ISBLANK and a few other ideas without success. If anyone has ideas on how to accomplish please let me know. I'm stumped.

ย 

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!