Form being able to be used to ask longer questions outside of dropdown selection
Has anyone been able to expand how forms are being used to ask more extended questions or have a workaround utilizing logic when creating a form?
I created a form (form should be the next image) using the drop-down opens added to a column on a sheet.
The process works to some point, but there is no logic available to identify if an item is picked since it is hard-coded in the column drop-down.
I am looking for ideas and hoping someone has found a workaround. Adding extra columns could work, but it is limited since it would mean potentially adding 100 columns and building logic to go with it. Plus, the column name length is limited, so the complete questions cannot be added.
Any advice would be greatly appreciated.
Answers
-
@tesman What are you trying to actually do? For the column names, yes they are limited, but in the Form, you can display a longer/alternative text than what is the column name.
-
I am trying to create a form to allow more extended questions to be added and read and then allow input and logic based on the answer to the question to feedback into the sheet. Most examples I see with the Smartsheet form are basic short questions or drop-downs for intake only. Through the Sheet drop-down, I am able almost to get there, but since it is in the drop-down from the sheet, I cannot put any logic on the response in the form.
-
@tesman A way around it could be to create a second sheet (i.e. reference) and list every single question displayed in the intake form, indent each drop-down option with those long descriptions. Add the reference sheet url to the intake form. Last, in your original sheet you can now simplify the wording of those long descriptions.
Help Article Resources
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
- 495 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!