Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Dynamic Drop Down list



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
    Travis Employee

    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
    Loann McGee ✭✭✭✭✭✭

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



  • Travis
    Travis Employee

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

  • 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
    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
    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. 






  • Tabitha Hunter
    Tabitha Hunter ✭✭✭
    edited 02/18/18

    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
    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.




  • Andrée Starå
    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!


    Andrée Starå

    Workflow Consultant @ Get Done Consulting


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

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

This discussion has been closed.