Altering logic based on previous answers
For my sheet, I currently have the following columns: "Change Reason," "Data Change," and a bunch of info collecting columns like "Department," "Manager," "Salary," etc...
I created a form so that the only thing initially seen is "Change Reason," and based on option chosen, different input would come up. For example, if "Promotion" is chosen for "Change Reason," then "Manager" and "Salary" would come up. If "Status Change" is chosen, then the dropdown option "Data Change" would show up with options like "Department," "Manager," "Salary," "Title," etc. Based on what is chosen, additional fields come up (if "Department" is chosen, then "Current Department" and "New Department" shows up) as well as showing up on Data Change.
I would like to know if it's possible so that if "Batch Change" is chosen for "Change Reason," none of the other follow up questions would come up, but only for "Batch Change." So if I were to choose "Batch Change" for "Change Reason," "Data Change" would show up and options can be selected, but nothing else would show up (only for "Batch Change," if "Department" is chosen, "Current Department" and "New Department" won't show up)
Asking if there's a way to alter logic for specific questions if a specific answer is chosen prior to the logic.
Glad to hop on a call or discuss further to see if we can find a solution!
Answers
-
@Christian Ong are you talking about logic on a form?
if so this help article should get you where you need to go: Use Conditional Logic to Streamline Form Submissions | Smartsheet Learning Center
-
Hi @Samuel Mueller,
Thank you for taking the time to answer my questions. In my form, I already have logic in place. I was wondering if there was a way to alter the logic based on which option is selected from the previous question.
For example, if I chose A for question 1, then B shows up, then within B, you can choose C or D, then C1 or D1 shows up based on what you chose. But if I chose E for question 1, then B shows up, then within B, you can choose C or D, but C1 or D1 won't show up, only if I chose E for question 1. (Hopefully this makes sense!)
Is there way to format the logic to show up like this?
-
@Christian Ong if you are referring to the the drop down options changing via logic then no, that is not possible. You can only determine which questions (or columns) show up based on the answer.
-
Thank you for the quick response. Let me know if there's any work on this topic!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives