NEWSheetSteps AI now turns entire websites into clean spreadsheet columnsExplore web scraping →

Google Sheets tutorials›Data validation›Create dynamic dropdowns

Google Sheets · Verified tutorial

Create dynamic dropdowns in Google Sheets

In H2, enter exactly =SORT(UNIQUE(E2:E6)) so the dropdown source updates from the raw statuses. Then create a dropdown in B2:B4 from H2:H4. Leave B2:B4 blank and do not change the raw status list.

Verified by PhilisJuly 15, 2026About 60 seconds

Quick answer

In H2, enter exactly =SORT(UNIQUE(E2:E6)) so the dropdown source updates from the raw statuses. Then create a dropdown in B2:B4 from H2:H4. Leave B2:B4 blank and do not change the raw status list.

Step-by-step

1

Select the targetIn H2, enter exactly =SORT(UNIQUE(E2:E6)) so the dropdown source updates from the raw statuses.

2

Complete the next actionThen create a dropdown in B2:B4 from H2:H4.

3

Apply the changeLeave B2:B4 blank and.

Shortcut or faster method

Select the target cell, type or paste the formula in the formula bar, then press Enter.

Expected result

H2:H4 contains the sorted unique status list, and B2:B4 uses it as a range-based dropdown source.

Common mistake

Changing the source values while applying the formatting or structure change.

Troubleshooting

Re-select H2 and repeat the final action. H2:H4 contains the sorted unique status list, and B2:B4 uses it as a range-based dropdown source.

Example spreadsheet data

This is the clean fixture used for the verified run.

Task	Status			Raw statuses
Draft brief				Draft
Review copy				Ready
Publish page				Draft
				Published
				Ready

Video transcript

Open the prepared Practice spreadsheet.
Select the target. In H2, enter exactly =SORT(UNIQUE(E2:E6)) so the dropdown source updates from the raw statuses.
Complete the next action. Then create a dropdown in B2:B4 from H2:H4.
Apply the change. Leave B2:B4 blank and.
H2:H4 contains the sorted unique status list, and B2:B4 uses it as a range-based dropdown source.