Move values from 1 sheet to another inside a Drop down box.

Alex Klingbeil

I'm looking to pull values from a column on Sheet 1 and use them in Sheet 2.

Sheet 2 is a form that team members fill out, and one of the fields asks for a person's name. Instead of having users manually type in names—which can lead to typos or inconsistencies—we’d like to turn that field into a dropdown menu. This would make the process more accurate and user-friendly.

Sheet 1 contains the list of people currently working on the project. Since this list is constantly growing, we’d like to automate the process so that any new names added to Sheet 1 are automatically reflected in the dropdown on Sheet 2.

Darla Brown

Hi,

Could you do an Index/Match to pull in names for your list that would automate that field? Or possibly an IF(OR statement pulling from your list to automate?

Thanks

Paul Newcome

There is a method using Data Shuttle that can be used if you have access to that. Otherwise you would need to use Bridge, the API, or some other similar third party app to automate it.

https://help.smartsheet.com/articles/2482755-dynamic-dropdowns-data-shuttle

.

Alex Klingbeil

@Paul Newcome so i have Data Shuttle Right. never got much Time to mess with it yet. would you have a link to anything on that to help me with my problem?

Paul Newcome

Yes. The link should be there in my last comment. It is the first link "Create dynamic Drop-downs with Data Shuttle | Smartsheet Learning Center".