Using a column date from sheet A to populate a dropdown in sheet B (Non data shuttle)

Craig F

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.

kowal

I think only Bridge has that functionality that added values from different columns as a dropdown list to another column. Have considered using it?

Craig F

https://community.smartsheet.com/discussion/comment/456233#Comment_456233

No, is that a plug in for Smartsheet?

kowal

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

Alex Argumedo

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.