Drop Down List Data Validation

kaitlin
edited 12/09/19 in Smartsheet Basics

My team and I are new to Smartsheet, and after 2 days of using the software, have already found a couple of major road blocks that will likely keep us from using Smartsheet. 

The biggest is the inability to create a drop down list that uses data validation to pull a list of options from another Sheet. (Example - one sheet be used to keep track of all products we offer, then be able to integrate that drop down into several sheets). It is not practical to ask my team to manually input/update the dropdown options on every sheet  when our product offerings update (frequently). 

I've seen countless threads here asking for the feature from 2015 - 2017, but see no resolution, other than some external services that provide a workaround, but these are costly, rely on Google Drive (not what most large corporations use), or the programs are now defunct or bought out by other companies.

Any solutions or suggestions here would be greatly appreciated, as we see the potential with Smartsheet, but need a bit more functionality to actually use it.

 

Comments

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Do you need to be able to use the dropdown via mobile?

     

    There is a solution for a dynamic dropdown list, but it is only usable on the web version.

    thinkspi.com

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi Kaitlin,

    I think it's my solution that Paul is thinking of. See original post below.

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

    Hope that helps!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Andree,

     

    That's the exact solution I was meaning. I just hadn't found it yet. Haha. yes

    thinkspi.com

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Haha!

    It's easier when you know what to search for wink

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E: [email protected]d.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Thank you Andrée! I'll give this a go, your sample link looks like it may work for us.

     

    Thanks again!

    Kaitlin

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Happy to help!

    Let me know if I can help in any way!

    Have a fantastic weekend!

    Best,

    Andrée

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • kaitlin
    edited 05/24/19

    Okay, last question! 

    Is there a way to copy the established "double click to select" cell and paste into several cells? or do you have to go through the entire process of setting up each individual linked cell to reference the original sheet? 

    Copy and Paste kills the link, and paste special with links is not available for these cells for me.

    Thank you,

    Kaitlin

    paste special.PNG

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    You have to copy and paste special in the same tab, and then it will work.

    Best,

    Andrée

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • jamieG
    jamieG ✭✭✭✭✭

    Kaitlin, please contact me at [email protected] I am working on this exact solution with the API and if you are interested, I could you assistance in beta testing it.