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
-
Give this a try...
=JOIN(COLLECT([Camping & Hiking]@row:[Wilderness Medicine Classes]@row, [Camping & Hiking]@row:[Wilderness Medicine Classes]@row, @cell <> ""))
Answers
-
Give this a try...
=JOIN(COLLECT([Camping & Hiking]@row:[Wilderness Medicine Classes]@row, [Camping & Hiking]@row:[Wilderness Medicine Classes]@row, @cell <> ""))
Help Article Resources
Categories
Check out the Formula Handbook template!