Dependent Dropdowns for Google Sheets™Install from Marketplace
Google Sheets guides

Build dependent dropdowns that stay understandable

Complete manual answers, tested product workflows, and honest explanations of the tradeoffs—whether you need two dropdowns or 5,000 connected rows.

Start here

How to Create Dependent Dropdowns in Google Sheets

The complete answer: how dependent dropdowns work, how to build them manually, and when the add-on is the cleaner option.

Read the complete guide
Category→Subcategory→Product
All guides

Choose the problem you are solving

6 tested guides
Core guide10 min read

How to Create Dependent Dropdowns in Google Sheets

The complete answer: how dependent dropdowns work, how to build them manually, and when the add-on is the cleaner option.

Read guide
Quick start6 min read

Set Up Dependent Dropdowns for Google Sheets™

A product-specific walkthrough from a highlighted source table to a working exact-cell Form or Repeating table.

Read guide
Scaling7 min read

Dependent Dropdowns for an Entire Column in Google Sheets

Use a Repeating table when every entry row needs its own independent Category → Subcategory → Item chain.

Read guide
Troubleshooting9 min read

Google Sheets Dependent Dropdown Not Working? 9 Fixes

Start with the symptom, identify the failing layer, and repair the dropdown without risking the values already in your sheet.

Read guide
Methods8 min read

Dependent Dropdowns in Google Sheets Without INDIRECT

INDIRECT is not the only option. Choose between a visible FILTER setup, custom Apps Script, or a maintained add-on.

Read guide
Hierarchies8 min read

Create Multi-Level Dependent Dropdowns in Google Sheets

Design a hierarchy such as Make → Model → Trim or Category → Subcategory → Brand → Product without separate lists for every branch.

Read guide
How these are made

Written against the product that actually ships

Every product workflow is checked against the current Dependent Dropdowns for Google Sheets™ sidebar. Formula guidance links back to Google’s own documentation, and screenshots come from the installed add-on—not a design mockup.

Want the shortest route?

Install the add-on, highlight your source table, choose your levels, and create your first three configurations free.

Install from Marketplace