How to Build a Dropdown from Another Sheet in Smartsheet

Updated 2026-11-20

The list you want in a dropdown usually already exists as a column somewhere — a client sheet, a product list, a register of cost codes. Here is how to turn that column into dropdown options, what Smartsheet's native linked dropdowns need, and what to do for the sheets they do not cover.

Native linked dropdown columns

Smartsheet's own answer is Linked Dropdown Columns, on the Pro, Business and Enterprise plans: a column's options are tied to a source sheet, so editing the source updates every linked dropdown automatically. If the list will keep changing, set this up first — it is the tidiest arrangement available.

  1. Open the target sheet in Table View — linked dropdowns can only be set up there, though they can be used from grid, board, timeline and the rest.
  2. Check your access: at least Viewer on the source sheet and Admin on the target.
  3. In the column's properties, link the dropdown to the source sheet and column holding the list.
  4. Edit the source when the list changes; every linked dropdown follows.

What linked dropdowns do not reach

They cannot be set up from forms, reports or Dynamic View, and they are a Table View arrangement on a paid plan. More to the point, they are something you set up going forward — they do nothing for the dozens of sheets that already carry plain, unlinked dropdowns typed in by hand, where the same list has quietly forked.

For forms specifically, Smartsheet also offers dynamic dropdown lists, which narrow one dropdown based on another answer — a different problem from keeping one list consistent in many places.

Push one column to a dropdown across many sheets

Our Master Dropdown takes the distinct values of one sheet column, sorts them into an option list, and applies them to a named column across every sheet you select — in one reviewable pass with a preview first. Plain text and number columns are converted to a dropdown as part of applying it.

Merge or replace is the decision that matters. Merge keeps each column's existing options and adds the new ones. Replace sets the options to exactly your list — and the thing to know is what that does to data already in the cells: existing cell values keep their text but stop being options, which is Smartsheet's behaviour for any dropdown edit, not something the tool chooses. There is a 15,000-option safeguard, which in practice catches the mistake of pointing it at a unique-ID column.

Editing an option list that already exists in many sheets is the neighbouring job, and our guide to editing a dropdown list covers it.

Official Smartsheet documentation: Linked dropdown columns, Dropdown column properties.

Do it in one pass instead

Turn one sheet column into a master list of dropdown options and push it to a column across many Smartsheets, with a preview before anything is written.

Try Master Dropdown Free

Frequently asked questions

Can a Smartsheet dropdown pull its options from another sheet?

Yes. Linked Dropdown Columns tie a column's options to a source sheet on the Pro, Business and Enterprise plans, so editing the source updates every linked dropdown. They are set up in Table View and need Viewer access to the source and Admin access to the target.

How do I apply one master list to the same column in many sheets?

A bulk tool can take the distinct values of a master sheet column and apply them as the options of a named column across every sheet you select, merging into the existing options or replacing them, with a preview of the resulting list before anything is written.

What happens to cells holding a value that is no longer an option?

The cell keeps its text but the value is no longer in the list, so it matches no current option. That is Smartsheet's behaviour for any dropdown edit, which is why replacing a list is worth previewing — and why renaming an option also means finding and replacing the old value in the cells.