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
- 66.6K Get Help
- 435 Global Discussions
- 152 Industry Talk
- 495 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 508 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
Trending in Formulas and Functions
- Good day Smartsheet Team, Getting an unparseable error on this formula: =IF($Name@row <> "",(SUMIFS({Expense}, {Period},1, {Type}, OR(@cell = "RES602782", @cell = "RES602497")),"") Trying to pull in a…
- I am working in a separate sheet for calculating metrics. I want to count the number of items in a referenced date range in another sheet that meet certain year criteria. For example, I want to find t…
- I have a column that is a contact list where a single or multiple staff members can be selected to be scheduled. I'm trying to create a formula that counts how many times each individual's names are l…