Drop down from another sheet

MJLaughlin

I have a need to populate a drop down list from the data in another sheet. Example - active projects list to populate the drop down "project name" in a communications intake form. Is this possible? So my project intake form is the data sheet for a vlookup for communications sheet?

Andrée Starå

Hi @MJLaughlin

I hope you're well and safe!

Try something like this.

I recently developed a solution for a client to keep dropdowns synced by using the Premium App, Data Shuttle.

More info: 

https://www.smartsheet.com/marketplace/premium-apps/data-shuttle

Is that an option?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

PPS Solutions

@MJLaughlin Hi hope you are well, we offer a cloud app that provides the updating you require included scheduled refresh times of your choice eg 2am every morning. Please see here and drop us a line if you would like a demo. Cheers

https://www.projectplanservices.co.uk/drop-down-sync