Drop down list from another sheet

sebastiani

Andrée Starå

Jan 20, 2022

Hi @eric_mixtape

I hope you're well and safe!

I recently developed a solution for a client where the Dropdown lists are kept updated using the premium app, 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!

Hi Andree,

Can you please detail how you use the data shuttle to generate the drop down on another sheet?

thanks,

Sebastiani

Danielle Wilson

@sebastiani There's some instructions on how to do that here! https://help.smartsheet.com/articles/2482755-dynamic-dropdowns-data-shuttle

sebastiani

Thanks! It worked!

Mary Kirby

Can Data Mesh help with updating dropdown lists?

Danielle Wilson

@Mary Kirby Unfortunately no! That's only a Data Shuttle feature.

agbush

Adding a voice - i think this should just be part of the core platform

Being able to maintain a list of project tags and properties in one set of sheets and then reference these as drop downs on other sheets summaries would be a amazing leap forward to facilitate portfolio reporting

EliHam

Hi @Danielle Wilson,

Our organization blocks attachments (I get a permission denied on the outflow execution even though I'm an owner on the target sheet) - is there another solution?

Thanks!

Danielle Wilson

Hi @EliHam certainly! Instead of making the offload / upload source a Smartsheet attachment, you can use any other Data Shuttle offload / upload source (e.g. Google Drive, Box, OneDrive, Sharepoint).

EliHam

hi @Danielle Wilson,

Unfortunately, all of those are blocked (it's a big enterprise that locks these things down). Is there any other way to do this?

Thanks,

Eli

Danielle Wilson

Hi @EliHam - are you sure your organization is currently using Data Shuttle? I would be a bit surprised if they were as Data Shuttle requires one of these options to function. I would recommend reaching out to your account team to discuss your options here a bit more!

enzo_vaire

Is Data Shuttle a paid app? I don't see why it would be necessary to deploy an extra app to populate from a sheet within Smartsheet - I understand the extra app to populate from other sources, but from a sheet within the same Smartsheet account?!? That seems like a major flaw.

DFoster99

Was looking for something like this, but I recognise why Smartsheet are avoiding this like the plague. Imagine the complexities in maintaining integrity in the list. How do you handle values removed from the list (keep, drop, flag, etc)?

Disappointing it is not in there, but it is a can of worms.

David Jasven

https://youtu.be/8AYfwDlMoDg?si=jqPfwd22YIAdDQKh

Hi All,

I pushed ahead and developed a tool for it. So it's solved.

You can see how it works in this demo video:

SMARTSHEET EXPERT CONSULTANT & DEVELOPMENT

David Jasven | Workflow and Business Process Consultant / CEO @ Must.do

W: www.must.do | E: smartsheethelp@must.do | WhatsApp: +1 347 380-7697

Feel comfortable to contact me for any help with Smartsheet, integrations, general business process advice, or anything else. I am more responsive on Whatsapp 🙃.

agbush

This is precisely why AirTable and others are doing well.

This is so basic.

There needs to be a way of referencing other sheets as drop downs in both i) Sheets columns and ii) Summary fields.

These crazy workflow automation solutions and 3rd party plugins are killing the product for such basic features.