01Recommended
Form
Pick one exact cell for each dropdown. Perfect for quotes, intake forms, calculators, and single-record workflows.
- Make can be B3
- Model can be F8
- Trim can be C14
New vehicle
Dodge⌄
Charger⌄
SXT⌄
Google Sheets™ add-on
Dependent dropdowns in Google Sheets, without the setup headache.
Turn one ordinary list into dropdowns that only show valid next choices. Pick Electronics and the next dropdown only offers Laptops and Phones.
Build a one-record form or a repeating table. Use 2–5 levels, place the dropdowns where they belong, and let the add-on keep every choice connected.
Free for your first 3 configurations. Pro from $2.50/month billed annually.
Interactive dependent dropdown demonstration
Four empty cells, driven by one flat source table.
Source
Catalog!A1:D76 of 6 match| Category | Subcat. | Brand | Product |
|---|---|---|---|
| Electronics | Laptops | Lenovo | ThinkPad X1 |
| Electronics | Laptops | Apple | MacBook Air |
| Electronics | Phones | Apple | iPhone |
| Electronics | Phones | Samsung | Galaxy |
| Home | Furniture | IKEA | KALLAX |
| Home | Appliances | Dyson | V15 |
Destination
Orders — row 5Category
Select…
2 optsSubcategory
Waiting…
—Brand
Waiting…
—Product
Waiting…
—Four empty cells, driven by one flat source table.
One source tableYour existing list of valid combinations
→2–5 connected choicesEach answer filters the next
→Cleaner sheet dataFewer impossible combinations
What Dependent Dropdowns for Google Sheets™ does
It creates and maintains connected dropdowns in the spreadsheet you have open.
Dependent Dropdowns for Google Sheets™ reads the source table and output cells you select in the current spreadsheet. It uses that access to create data-validation rules, show only valid next choices, and clear later answers when they no longer match.
Your spreadsheet cell values and dropdown selections stay inside Google Sheets™ and are not sent to Codeprint. Codeprint receives only the account, usage, and billing information needed to provide the Free and Pro plans.
See exactly how Google data is used →The idea in 10 seconds
Your list already contains the rules
You do not write conditions. If a combination exists in your source table, people can select it. If it does not, they cannot.
| Make | Model | Trim |
|---|---|---|
| Dodge | Charger | SXT |
| Dodge | Challenger | R/T |
| Dodge | Durango | GT |
| Ford | Mustang | Dark Horse |
| Toyota | Camry | XSE |
Vehicle request
That's it. Ford and Toyota models never appear because they do not match Dodge.
Fits the sheet you are building
One picker or a whole table
Use the same source data in two different ways. The add-on walks you through both.
02
Repeating table
Pick one starting cell. The add-on places each level beside it and fills down for every row.
- Ideal for logs and trackers
- Hundreds of entry rows
- Each row works independently
MakeModelTrim
Dodge⌄Charger⌄SXT⌄
Ford⌄Mustang⌄GT⌄
Toyota⌄Camry⌄XSE⌄
Made for real work
If your choices have an order, this fits
The labels can be anything. What matters is that each choice should narrow what comes next.
01Vehicle order form
Make→Model→Trim
Dodge⌄Charger⌄SXT⌄
Choose Dodge and Model only shows Dodge vehicles.
02Product request
Category→Brand→Product
Laptop⌄Apple⌄MacBook Air⌄
Nobody can pair a product with the wrong brand.
03Location picker
Country→State→City
United States⌄Texas⌄Austin⌄
Each location choice narrows the next one.
04Request routing
Team→Request→Owner
Finance⌄Invoice⌄Accounts Payable⌄
Requests reach the right person with less cleanup.
No spreadsheet expertise required
Three decisions. The sidebar does the rest.
If you can highlight cells, you can build this.
Highlight the list you already have
Select the headers and the rows beneath them. The add-on reads the level names for you.
A1:C500Confirm the order
Put the broad choice first and the specific choice last: Make → Model → Trim.
1 → 2 → 3Choose where they go
Assign exact cells for a Form, or one starting cell for a Repeating table. Then press Create.
B3 · F8 · C14Fast where it matters
The next choice is ready when you are
Form dropdown options recalculate inside Google Sheets, so the next list narrows immediately. The add-on safely clears a later answer only when it no longer fits.
Electronics→Laptop or Phone→Matching brands
01Your sheet stays yours
Spreadsheet values and dropdown choices are not sent to Codeprint.
02Native Google Sheets controls
People use familiar dropdowns directly inside the cells.
03Repair without panic
If a rule is removed, the sidebar shows Needs repair and gives you one clear action.
04Grow without rebuilding
Use up to five connected levels and manage multiple configurations from one sidebar.
Quick answers
What people want to know first
Do I need to write formulas?+
No. You choose the source table, the dropdown order, and where the dropdowns should go. The add-on handles the working setup.
Can the source data live on another sheet?+
Yes. Your source list and your finished dropdowns can live on different sheets in the same spreadsheet.
What happens if I change an earlier answer?+
The choices below it narrow immediately. Any later value that is no longer valid is cleared safely.
Can I build a form instead of filling an entire column?+
Yes. Form mode lets you choose one exact cell for each level—even when those cells are far apart.
Does Codeprint receive my spreadsheet data?+
No. Spreadsheet values and dropdown selections stay inside Google Sheets.
Start with one list
Make the next choice obvious.
Your first three configurations are free. No card required.