DROP DOWN LIST FROM ANOTHER SHEET

Improve Consulting

Can the selections for my dropdown list come from a separate sheet, such that when I edit the sheet the dropdown options automatically change too?

Mark Cronk

Hi @Improve Consulting ,

Unfortunately this isn't a current capability. It is a common question and on the enhancement list. Andree Stara has posted a couple workarounds if you think they're worth the effort.

Mark

Neil Watson

These two companies offer a solution. They are outside of Smartsheet. I am not affiliated with either:

https://smarterbusinessprocesses.com/

https://ddupdate.com/

Some people have expressed security concerns since both solutions use the Smartsheet API but I am not technically competent to speak to this point.

Hopefully, Smartsheet will develop an internal solution at some stage.

Bassam Khalil

Hi @Improve Consulting

Hope you are fine, as @Mark Cronk mentioned the following solution by Andree Stara could help you please check it

Dropdown list from another sheet

Mark Cronk

Hi @Improve Consulting ,

Unfortunately this isn't a current capability. It is a common question and on the enhancement list. Andree Stara has posted a couple workarounds if you think they're worth the effort.

Mark

Neil Watson

These two companies offer a solution. They are outside of Smartsheet. I am not affiliated with either:

https://smarterbusinessprocesses.com/

https://ddupdate.com/

Some people have expressed security concerns since both solutions use the Smartsheet API but I am not technically competent to speak to this point.

Hopefully, Smartsheet will develop an internal solution at some stage.

Bassam Khalil

Hi @Improve Consulting

Hope you are fine, as @Mark Cronk mentioned the following solution by Andree Stara could help you please check it

Dropdown list from another sheet

Anne-Solene Monrouzeau

I have the same question and don't have access to the data uploader with my license. Any other idea to workaround this issue? When do you expect the functionality to be released in Smartsheet?

Improve Consulting

Thanks All.

Bassam Khalil

@Improve Consulting 

You are more than welcome

PPS Solutions

@Improve Consulting Hi, feel free to take a look at our Sync App which provides the capability you are looking for https://projectplanservices.co.uk/dropdownsync Cheers

Cemil Binlik

I think this needs to be implemented into SmartSheet asap as this is a very basic function and shouldn't be too tough to implement. I'm working on multiple sheets with a drop down of employee list and you can imagine what a burden to update all those dds as there is a circulation of employees at all times

Mr Keith G

https://community.smartsheet.com/discussion/comment/338737#Comment_338737

Absolutely. Just ran into this issue. About 10 sheets with 100 employees that have to be updated every addition/subtraction. Frustrating.

EV_1

Can we please add to Smartsheet the functionality to link dropdown options in one sheet to another sheet as it's clearly a need?

Thanks.

David Jasven

Hi All,

It was a big need for me and I had no choice but to solve it. See the video I put together to show how I achieved it.

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

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. 👨‍🎓