Dynamic Drop Down list

Matīss Lācis

Hello!

As you have already seen in forums, many customers demand drop down lists, that uses master column as the list entires. Whenever you add a new entry, the list in all other sheets updates with this new item.

Do you have any other way to get this done, for example, external database linking or other solutions. We are willing to buiy enterpise version of Smartsheets if you can manage to solve this problem.

Thank you!

Travis

Hello - check out this thread where Richard said his company was working on a workaround for this: https://community.smartsheet.com/discussion/suggestion-dynamic-lists

Loann McGee

Travis - just an FYI that the workaround hasn't yet been posted to the above link. 

Blessings,

Loann

Travis

Thanks Loann, I will post in the other discussion to see if there is an update 

Matīss Lācis

The non-database enviroment is not suitable for us. I will stay updated if you add dynamic dropbdown list and other features that we would need.

If any of you have a solution for this or you know how to link Smartsheet with a database then please write here or personal message.

Richard Rymill SBP

Daynamic List updating from one sheet to many sheets has now been tested by us using an API and it works well and has many uses. 

One of the nice added benefits is that the revised Dropdown list appears in SmartForms associated, so no need to revise your forms, it happens automatically. 

This is a big time saver and adds to Data consistency but there is a cost, so users would need to be able to justify some budget. However most of thioe asking for this have been large corporates so we suspect a small cost will be acceptable? 

 

Happy to demonstrate and discuss if anyone in the community wants to know more? 

Regards RichadR 

Smarter Business Processes. 

Dennis Kyle

Hi Richard,

 

I'd love to see how you have done the API integration.

Richard Rymill SBP

Hi Dennis

I can run through a demo for you so you can see if it would be helful to you? 

Can you drop me an email to arrange? I dont have any contact info for you? 

I am on UK GMT time. Cant see where you are but sure we can fit in. 

 

richardr@smarterbusinessprocesses.com 

 

Regards

 

Tabitha Hunter

I also need this and do have the enterprise version.  If this is not a feature that is going to be developed, does anyone have a work around?

Richard Rymill SBP

Hi Tabitha, while we wait for Smartsheet to provide this functionality, there are a choice of ways to achieve this so we need to understand why and how this lack of functionality is affecting you and measure that against the available solutions. 

If you can email me at RichardR@smarterbusinessprocesses.com we can arrange a Zoom video-con? 

I am in the UK  and our team work in all timezones.

RichardR

 

 

Andrée Starå

Hi all,

Here is a workaround that gives you the possibility to use lists of information and choose from that list inside a sheet (doesn't work with mobile, only desktop)

I'm utilizing cell-linking for this workaround. The main sheet is linked to the dropdown/list sheet.

Please see the attached link/screenshot for more information.

Example of dropdown/list

I hope this can be helpful for you!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting