@Neil Egsgard Yes. I use this pretty frequently, but it does (as you pointed out) have its limitations. You can set up a date shuttle workflow to export a list from a Smartsheet into a .csv file and have it automatically attached to a sheet and then use a separate workflow to re-upload you dropdown options.
If you have ALL of your dropdown tables on a single sheet, you can set up this offload one time and then take care of the mapping in the upload workflows. You can map on .csv column to multiple dropdown columns, but you do need a separate upload workflow for each sheet.
This is so long overdue. Having to use data shuttle or third party solutions for something like this is silly.
This feature has been requested for years now. Long overdue.
I agree with previous commenters. Data Shuttle is the Smartsheet-endorsed solution at the moment, and it works great, but it would be such a game changer together with the other dropdown list enhancements to have it built in.
2023 = the year of dropdown list improvements? 🙏
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 for help with Smartsheet, integrations, general workflow advice, or anything else.
This prohibits me from considering smartsheets for some data management projects as without this functionality I have to update any lists/drop-downs manually. I understand I can purchase an "upgrade/premium service" to have this ability but should something that is easily accessible in Excel and Access be a(n) "upgrade/premium service"?
I have many drop-down lists with a contact data and I would like to have possibility to update this list from a different column with contact data. If new employee appears in the company I would like to update 1 HR list and link it with my drop down list to have always updated contact data in my drop down list and not be forced to update it each time.
Very easy to do with API call. I use an inexpensive integration application called Make (formerly Integromat). Let me know if you want to learn how.
Interested to know more about how you're using Make for this, Marc.
@James Vandezande I'll put a video together for you.
Here is the video link. I know this will probably seem complicated. Make is a great program that works very well with Smartsheet. If you get into that environment and learn it, you can probably make sense of this. I hired someone to help me get started for the first time and now I can build automation with ease.
Update Dropdowns in Smartsheet (vimeo.com)
Thanks @Marc Hauge - I'm going to watch that more carefully after the weekend. Just wanted to express my thanks now!!
Having a Report (column) be the source data (as well as a Sheet/Column) for this would also be useful, as we can use a report to filter and sort data sheet rows.
Currently each drop-down list must be maintained individually. It would be very useful if a drop-down list could reference a list of options on a sheet. This way drop-downs on different sheets that use the same list (ex. all employees) could be maintained in one spot to ensure they're always consistent and less tedious to update.
A way to select the source list for a drop-down column, similar to excel's data validation.
It would be most useful if this would be able to link the column of a different sheet and use the values listed as the option for the column drop-down.
You can do this with data shuttle or bridge. https://help.smartsheet.com/articles/2482755-dynamic-dropdowns-data-shuttle
Hi Community, Welcome to the Product Feedback and Ideas space where you can help shape the future of Smartsheet! We really appreciate your feedback and will take all posts into consideration. Our product team will review top ideas and requests monthly and we'll share updates as soon as we get them. Remember: if you have a…
It would be great to be able to group columns... for various reasons. One major one for me would be for hiding & unhiding info. Similar to the way you can click the filter button once to filter versus unfiltered, it would be nice to be able to "Hide Column Group" or "Unhide Column Group"... this is something that would…
Although it's typical to need to run a few tests for a workflow or automation, it would be great if we had the option of previewing what the automated emails/notifications/alerts would look like for individual users with different types of permissions. A view "View As" type of feature.
When a project and tasks are set up with dependencies and durations, the project manager should be able to drive all task dates based on the project end date, not just the start date. Often mid project the delivery date needs to be changed. With Smartsheet, a project manager needs to adjust the duration of all tasks…
©2023. All Rights Reserved Smartsheet Inc.