Not automatically when a record is saved....
If you have Data Uploader, one of the options in DU is to update Dropdowns. You could do something fancy where you export data (via scheduled report) from your sheet to Google Drive, have Data Uploader scheduled to pick up that report and update Dropdowns from it, but...
Everything would have to be scheduled - so it wouldn't update automatically. (Plus, you'd have to have Data Uploader, which is an add-on)
But, if you don't have to send the alert out immediately, you could do it:
Create a report that pulls values from that column. Run the report on a schedule (this part is manual) and save as CSV or XLSX in Google Drive, One Drive or Box. Set up Data Uploader to look in this location and automatically run when it finds a new file.
Then set your alerts to trigger late at night or early in the AM after the report and data uploader have run...
(but really, if you're going to do all that, it might be easier to just manually update the drop-down)
Can you create a drop down list from values in a column?
Im trying to create a drop down list in a form and have choices from a column. The idea is for overtime. The supervisor enters a time frame on the sheet, people are alerted this has been posted and they go in and fill out a form choosing that overtime option from a drop down list. Can this be done?
Best Answer
-
Not automatically when a record is saved....
If you have Data Uploader, one of the options in DU is to update Dropdowns. You could do something fancy where you export data (via scheduled report) from your sheet to Google Drive, have Data Uploader scheduled to pick up that report and update Dropdowns from it, but...
Everything would have to be scheduled - so it wouldn't update automatically. (Plus, you'd have to have Data Uploader, which is an add-on)
But, if you don't have to send the alert out immediately, you could do it:
Create a report that pulls values from that column. Run the report on a schedule (this part is manual) and save as CSV or XLSX in Google Drive, One Drive or Box. Set up Data Uploader to look in this location and automatically run when it finds a new file.
Then set your alerts to trigger late at night or early in the AM after the report and data uploader have run...
(but really, if you're going to do all that, it might be easier to just manually update the drop-down)
Answers
-
Not automatically when a record is saved....
If you have Data Uploader, one of the options in DU is to update Dropdowns. You could do something fancy where you export data (via scheduled report) from your sheet to Google Drive, have Data Uploader scheduled to pick up that report and update Dropdowns from it, but...
Everything would have to be scheduled - so it wouldn't update automatically. (Plus, you'd have to have Data Uploader, which is an add-on)
But, if you don't have to send the alert out immediately, you could do it:
Create a report that pulls values from that column. Run the report on a schedule (this part is manual) and save as CSV or XLSX in Google Drive, One Drive or Box. Set up Data Uploader to look in this location and automatically run when it finds a new file.
Then set your alerts to trigger late at night or early in the AM after the report and data uploader have run...
(but really, if you're going to do all that, it might be easier to just manually update the drop-down)
-
Mcorbin, this is such a creative solution to the issue. I have however come to another solution that will overall accomplish what I’m trying to do without updating a drop down list. Thank you so much for this as I will probably use it for another project or Smartsheets could just allow dynamic drop downs from sheets.
-
www.ddupdate.com does what you are talking about. :D
-
@aerickson - what was your work around if you don’t mind me asking? I’m in the same boat hoping you figured this out!
-
Yeah, this seems like it would be out of the box functionality, but looks like another premium add on.
-
People have been asking for the Smartsheet team to add this for years! It would be such a game changer.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.7K Get Help
- 438 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 509 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
Trending in Formulas and Functions
- Hi! I cannot figure this out. I have a "% Complete" column (0, 25, 50, 75, 90, 100, Cancelled). I made a simple checkbox column that should be checked if the item's "% Complete" value is equal to anyt…
- This formula keeps coming up as #UNPARSEABLE. I have checked the name of the columns, they are correct. Any ideas? I am trying to show the days remaining in a project. =IF([% Complete]@row = 1, "", NE…
- Hi All! I´m trying to find the error in this formula but have not been able to find the solution after many attempts. Any ideas? =IFERROR(IF([To Date]@row <> "", IF([To Date]@row < TODAY(), "RED", IF(…
