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

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

Answers

  • Nick Korna
    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!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!