Drop Down List Data Validation
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
-
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.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
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.
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: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.
-
Andree,
That's the exact solution I was meaning. I just hadn't found it yet. Haha.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Haha!
It's easier when you know what to search for
SMARTSHEET EXPERT CONSULTANT & PARTNER
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.
-
Thank you Andrée! I'll give this a go, your sample link looks like it may work for us.
Thanks again!
Kaitlin
-
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: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.
-
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 -
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: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.
-
Kaitlin, please contact me at jamie@jamiegamauf.com. I am working on this exact solution with the API and if you are interested, I could you assistance in beta testing it.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 213 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives