One Column, Every Dropdown
Stop typing the same dropdown options into sheet after sheet. Use one column as the master list and push its distinct values to a column across as many sheets as you like.
Connect Smartsheet to StartWhy teams use it
One source of truth
Pick a master sheet and column — its distinct values become the dropdown options everywhere else.
Apply to many sheets at once
Push the same option list to a named column across every target sheet you select, not just one.
Merge or replace
Add the new options to what is already there, or replace the list outright — your choice.
How it works
Choose the master sheet and column
Pick the sheet and column whose distinct values become the dropdown options.
Choose target sheets and column
Select the sheets to update and the column name to apply the dropdown to.
Review, then apply
Preview the option list, choose merge or replace, and confirm.
Frequently asked questions
How do I edit a dropdown list across many Smartsheets at once?
Point this tool at a master sheet and column — its distinct values become the option list, which is then pushed to the same column name across every sheet you select.
Will it overwrite my existing dropdown options?
Only if you choose to. You can merge the new values into the existing list, or replace it outright.
Does it work on plain text columns?
Yes. Text and number columns are automatically converted into a dropdown when you apply the target column.
Is there a usage limit?
Previews and dry runs are unlimited and never count. Applying changes (a real write) is capped at 3 bulk runs per account per day while the tool is free, and a single run can span up to 5 sheets. The counter resets daily.
Ready to get started?
Connect your Smartsheet account and try it in minutes.
Connect Smartsheet to Start