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
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!