Using a column date from sheet A to populate a dropdown in sheet B (Non data shuttle)
I'm looking for a way to populate a drop down automatically from data entered into a seperate sheet.
We have a central "New Projects" sheet which acts as master data sheet. Several other sheets use forms that have a dropdown to choose the project, where the dropdown data is taken from the New Projects sheet. We have until recently been using data shuttle. Apparently we've used some 2m plus rows (no idea how since we only have roughtly 100 active projects and filter in active). Smartsheet are now looking for extortionate sums to allow us to continue using Data Shuttle, and I don't believe we should be paying $10k's for a massive gap in functionality!
I have access to Zapier, and Power automate, so would welcome any suggestions for a work around, please.
Answers
-
I think only Bridge has that functionality that added values from different columns as a dropdown list to another column. Have considered using it?
The Smartsheet Lover
Is there anything else we can help you with?
MASA Consult - Your Aligned Smartsheet Partner
Find us on LinkedIn!
-
No, is that a plug in for Smartsheet?
-
it's a smartsheet product that connects different systems so you can have everyting in smartsheet like weather from AccuWeather, positions from google maps etc.
it also allows to create dropdown lists dynamically in smartsheet based on the data in other sheets etc.
https://youtu.be/RFaICz9GDaQ
The Smartsheet Lover
Is there anything else we can help you with?
MASA Consult - Your Aligned Smartsheet Partner
Find us on LinkedIn!
-
It is possible to create dropdowns using the API only, we created a reference sheet that contains, dropdown_source_sheet, dropdown_column_name, Destination_sheet, destination_column.
The script comes and reads the source sheet, create a list of the elements from the source column, then go to the destination and update the column "options" in the dropdown, not the value, (convert the list to a comma delimited string before posting).
done.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives