Forms / Worksheets and Dropdowns

ss_happychappy

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.

Ella

@ss_happychappy drop-down lists can be automatically updated via Data Shuttle. Not sure if you have this available under your plan.

ss_happychappy

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?

Paul Newcome

The only other alternatives are through the API or the premium add-on Bridge.