Forms / Worksheets and Dropdowns
Hi,
I have a task to create a form(s) for a user to complete.
As part of the form there is a question, with a yes / no dropdown. If the user selects no I would like them to select a predefined answer.
The piece I cannot work out so please share your thoughts :)
We have multiple rows (and three columns) on another sheet that I wish to pull from, think of a vlookup, however on the form I wish all these rows to be in a dropdown menu for the user to select. Please note the rows are in a different worksheet.
In summary.
I have one worksheet with a form. On this form a user should be able to select an answer from a dropdown list of entries. This list is stored in a separate smartsheet and will continue to be maintained and updated on that form. How can I pull in the entries from worksheet (2) into worksheet (1).
Thank you in advance.
Answers
-
@ss_happychappy drop-down lists can be automatically updated via Data Shuttle. Not sure if you have this available under your plan.
-
HI @Ella Thank you for the response.
We do not subscribe to data shuttle, do you or anyone on this forum have an alternative(s) idea please?
-
The only other alternatives are through the API or the premium add-on Bridge.