DROP DOWN LIST FROM ANOTHER SHEET

Improve Consulting · 02/22/21

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 · 02/22/21

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 · 02/22/21

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

Smarter Business Processes

https://smarterbusinessprocesses.com/

We Help Businesses Improve their Business Processes with Better Visibility of Important Information, leading to More Collaboration and Greater Productivity.

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 · 02/22/21

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 · 02/22/21

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 · 02/22/21

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

Smarter Business Processes

https://smarterbusinessprocesses.com/

We Help Businesses Improve their Business Processes with Better Visibility of Important Information, leading to More Collaboration and Greater Productivity.

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 · 02/22/21

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 · 02/22/21

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 · 02/22/21

Thanks All.

Bassam Khalil · 02/23/21

@Improve Consulting

You are more than welcome

PPS Solutions · 03/01/21

@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 · 08/04/22

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 · 12/04/22

Cemil Binlik

Aug 4, 2022

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

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

EV_1 · 02/17/23

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 · 06/27/24

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.

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

Smartsheet Basics

Smartsheet Basics

DROP DOWN LIST FROM ANOTHER SHEET

Best Answers

Smarter Business Processes

Answers

Smarter Business Processes

Quick Links

Categories

Trending in Smartsheet Basics

Has anyone tried to create a trivia game using Smartsheet?

What's the maximum number of rows in a sheet ? Is there any limitation on the number of columns ?

Sharing Permission; Shared Sheet Management for Unlicensed User/Free Collaborator