How to Build Nested ISBLANK or NOT ISBLANK Formula?

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!