Options offered for selection depend on the selection made in a different column

Avital Bar

How can you create a situation where the options offered for selection in one column depend on the selection made in the previous column? (and specifically having so in a form)

Thanks

Nick Korna

Hi @Avital Bar,

Having come across this exact situation, my solution was to have multiple columns depending on the selection. From there, a nested IF statement can be used for a combined column - IF(Selection@row = A, AnswerA@row, IF(Selection@row = B, AnswerB@row.... ) etc.

The additional columns can be hidden on the sheet itself and logic in the form means they are only visible when the relevant selection is made.

Hope this is of some assistance!