If one of four answers given in column1, different columns populate as follow-up questions
Question in column1 has four possible answers. Depending on which of the four answers are provided, I would like to provide column2, column3, column4, or column5 as follow up questions. Is there a formula or automation to do this? Thanks!
Best Answer
-
The easiest way to do this is via a form. You have conditional logic within the form that can show what you want based on how the person answers the base question.
Jonathan Sanders, CSM
"Change is always scary because it is unknown, but facing the unknown is what makes us stronger."
Answers
-
The easiest way to do this is via a form. You have conditional logic within the form that can show what you want based on how the person answers the base question.
Jonathan Sanders, CSM
"Change is always scary because it is unknown, but facing the unknown is what makes us stronger."
-
Thank you, @Kleerfyre! That worked perfectly:)
-
Glad I could help!
Jonathan Sanders, CSM
"Change is always scary because it is unknown, but facing the unknown is what makes us stronger."
-
@Kleerfyre Is there a way to actually do it in the sheet and not a form?
-
Smartsheet doesn't dynamically hide or show columns based on cell entries.
Jonathan Sanders, CSM
"Change is always scary because it is unknown, but facing the unknown is what makes us stronger."
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!