Datasources for Dropdown Menus
Comments
-
@Serg80 No. It is pretty much as simple as how I described it.
-
This would be an upgrade to the Data Shuttle option!
-
Hey everyone,
I put a similar call out in this thread! Iβd love the opportunity to connect with some of you to better understand how the absence of what we're calling managed dropdowns have impacted your workflows in Smartsheet and how you envision using them. Your insights will help us shape the best possible solution.
My email isΒ james.lee@smartsheet.comΒ if you would like to get in touch.
I look forward to hearing your thoughts!
Regards,
James -
We really need this. We have a list of "Employees" that we use across multiple sheets. We like for these columns to be a drop down so no mistakes are made. We also have a list of inventory items that we use across multiple sheets. Same scenario, we don't want spelling mistakes or items that are not in the list added. We are currently updating about 10 sheets with drop down list.
-
when creating a form and inclusing a dropdown, it would be ideal if the items in the dropdown could be pulled from a live list, so in Table/List A we have a list of items and on table B we have a column with a dropdown that calls the items on table A and we only need to upkeed table A
-
A lot of SSFeatures have requested this feature, so I've done a bit of research into the solutions for this.
Here are the list of solutions that I've found:
DataShuttle by Smartsheet - You can achieve this in Data Shuttle if you have that addon, but it requires a configuration for each data source/destination.
Dropdown Update for Smartsheet - Probably the simplest of all of the options.
SmartLink by @Gia Thinh - This one uses Webhooks to keep your data in sync in real time, which is really nice. Some of the other ones only update your data every few minutes, whereas this one updates the data right when it happens.
Solution Manager by SoftwareX - The dropdown updater is bundled with their solution manager, so it comes with a bunch of other useful tools besides just the dropdown updater. I believe that this one works with Control Center builds. Maybe someone from the SoftwareX team can confirm.
Smarter Dropdown List Manager by Smarter Business Processes - You configure the dropdown data sources in a Smartsheet sheet. Which is really nice! The configuration lives in Smartsheet, rather than needing to configure everything in a custom web app.
I'm sure there are others out there as well!
Nathan Braun (Founder of SSFeatures) (nathan@ssfeatures.com) (LinkedIn)
SSFeatures makes Smartsheet way easier to use and it saves you hours of work every week. It adds essential features into Smartsheet to save you time. For example: β Auto Sorting β Sorting with Filters β Report PDF Generation β Copy and Paste Conditional Formats β Copy and Paste Automation Workflows β Column Manager β and so many more.
-
Hello! I was thinking about how it would be amazing to have the option to have options within a column automatically adjust and change based off of data in another sheet. In my organization, a lot of forms are used and the data changes all the time. It would be so much more streamlined to not have to go in each time and update the columns every time something changes.
