Sign in to submit new ideas and vote
Get Started

Datasources for Dropdown Menus

Options
Dan Cliff
Dan Cliff ✭✭✭✭

A sorely missing feature from Smartsheets right now is the ability to link dropdown menus to a central datasource - currently when designing sheets with dropdown menus, you need to manually update every sheet where the list exists making change management a pain.

If we could populate those dropdown menus from a reference sheet instead, this would go a long way to improving the user experience for change management.

Tags:
362
362 votes

On Wishlist · Last Updated

«13

Comments

  • Cheree Peterson
    Options

    Yes as well as an easy way to see what entries have been overridden and contain a selection that is not in a drop down list. I get a message that says 18 cells have values that are not in drop down lists but I can not find a way to show me those 18 entries without exporting the dropdown list to a separate sheet, then creating a flag column to show which ones are not in the list. Now I have to maintain 2 lists. Smartsheet already knows there are 18 so it would be great if it could show me those 18.

  • Kimberly Gammon
    Options

    Totally agree with Cheree -- a filter option of "value not in dropdown list" would be a great way of handling it

  • Olen Ronning
    Options

    We love the idea of dynamic dropdowns. This seems to also be related to another idea here: https://community.smartsheet.com/discussion/92421/dynamic-dropdowns. For those that are interested, we would love learn more about your specific scenarios and how this feature would work best for you. You can schedule time to connect with me at: https://go.oncehub.com/OlenRonning

  • Adrian Mandile CHESS
    Adrian Mandile CHESS ✭✭✭✭✭
    Options

    Yes, agree very much.

    This could be achieved most simply by using a similar means as for defining 'external references' in formulas when pointing to a master/reference data sheet. Or for more specific row/record selection, it could allow us to use a COLLECT() function on that external reference.

  • Stephanie09
    Options

    Drop down lists that feed into forms and other parts of sheets often change, ie. Contact Lists as Companies Change, Product lists, Optional Menus etc.. It would be extremely efficient to have one sheet that manages all drop down categories and as Sheets are built you select the Drop down category for that list (or continue to build manually). The dropdown streamline would make merging data across multiple sheets have stronger data integrity (no spelling errors etc..) and also be significantly easier to update once list vs. trying to find all places that common list applies too within your sheets.

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    edited 10/06/22
    Options

    I agree that this would be a great feature added to the core product, but in the meantime there is an option to use Data Shuttle (if you have access to it). Basically you create an offload workflow from the master sheet and then create an upload workflow to change the dropdown values on the target sheet.

  • Jim Gibney
    Options

    This would dramatically improve the use of Smartsheets and seems like a no-brainer. Allow the creation of Workspace level named ranges, allow these named ranges to be used to populate drop down lists. Similarly, allow creation of Workspace level contact list, this then used to drive contact fields contents with filtering option.

  • Emmet McKenna
    Emmet McKenna ✭✭✭✭
    Options

    https://ddupdate.com/ is a great solution for this. You can setup a sheet in Smartsheet with the list of what you want on the dropdown e.g. current employees. This can then be linked across multiple sheets, if a new employee starts you can add it to the one sheet and this will then update all the linked dropdowns.

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Options

    Please keep in mind the ddupdate is not created by, endorsed, etc. by Smartsheet. It is a 3rd party app which means due diligence should be used before connecting to it especially if you have privacy concerns.

  • Ryan Sides
    Ryan Sides ✭✭✭✭✭✭
    Options

    WorkflowCreative.com

    Our app dynamically updates your dropdowns when your source data changes! It sounds like what you mentioned.

    Ryan Sides

    Smartsheet Tips and Tricks for Beginners and Advanced on LinkedIn and YouTube

    Come Say Hello!

  • Gwen Rymill SBP
    Gwen Rymill SBP ✭✭✭✭
    Options


    See our Smarter Dropdown List Manager for Smartsheet which updates data values in a master dropdown list that then automatically updates matching dropdown lists in other nominated sheets

    https://www.smartsheet.com/marketplace/apps/smarter-dropdown-list-manager-smartsheet

  • Neil Egsgard
    Neil Egsgard ✭✭✭✭✭
    edited 02/24/23
    Options

    The best way I found to update a drop down list was with Data Shuttle.

    https://help.smartsheet.com/articles/2482755-dynamic-dropdowns-data-shuttle

    It is still a poor solution because you have to:

    1. Upload a file to have the drop down list change.
    2. Have a Data Loader for each drop down list you want to update. This means a Data Loader per sheet needing updates.

    Having a dropdown list data that could be referenced by multiple sheets would be a huge help.