Create cascading dropdowns in Google Sheets™ without formulas or code. Parent choices automatically control the options shown in every following dropdown.
Fortegnelse opdateret:20. august 2026
Fungerer sammen med:
Ingen anmeldelser
21
Oversigt
Dependent Dropdowns for Google Sheets™ makes it easy to create cascading dropdown lists without writing formulas, scripts, or complicated validation rules.

Choose a value in the first dropdown and each following dropdown automatically shows only the matching choices.

For example:

Make: Dodge
Model: Charger
Trim: Scat Pack

If Make changes to Ford, outdated Model and Trim selections are cleared and replaced with the valid Ford options.

HOW IT WORKS

Start with a simple source table containing the valid combinations for your workflow. Then use the guided sidebar to choose the dropdown hierarchy and decide where each dropdown should appear.

Dependent Dropdowns for Google Sheets™ creates and maintains the connected dropdowns directly in the spreadsheet you have open.

TWO FLEXIBLE LAYOUTS

Form layout

Place each dropdown in an individually selected cell. This is ideal for guided forms, quote builders, intake sheets, order forms, product selectors, and reusable templates.

Repeating table layout

Apply the same dropdown hierarchy across multiple rows. Each row works independently, making this layout useful for inventories, trackers, catalogs, project logs, and structured data entry.

KEY FEATURES

• Create dropdown hierarchies with two to five levels
• Build connected dropdowns from a flat source table
• Show only choices matching the previous selection
• Place Form dropdowns in individually selected cells
• Apply repeating dropdowns across multiple rows
• Automatically clear child selections that become invalid
• Manage multiple independent configurations
• Pause and resume configurations without deleting them
• Detect damaged configurations and guide users through repair
• Continue using existing configurations if Pro ends
• Connect automatically without a separate account sign-in

BUILT FOR EVERYDAY USERS

The guided sidebar explains each step in plain language. Choose the source list, confirm the order of the dropdowns, select where they should appear, and create the configuration.

No Apps Script knowledge is required.

COMMON USE CASES

• Vehicle Make → Model → Trim selectors
• Country → State → City fields
• Department → Team → Employee assignments
• Category → Subcategory → Product selectors
• Product → Size → Color order forms
• Building → Floor → Room selectors
• Project → Task → Assignee trackers
• Region → Location → Store lists
• Course → Class → Section enrollment forms

FREE AND PRO

Free includes three configuration creations for the lifetime of the account. No payment card is required.

Pro provides unlimited configuration creation:

• $4.99 per month
• $29.99 per year

Editing, repairing, pausing, resuming, and deleting existing configurations do not consume the Free allowance. Existing configurations continue working if a Pro subscription ends.

PRIVACY BY DESIGN

Spreadsheet content stays inside Google Sheets™ and Google Apps Script during normal dropdown operation.

Dependent Dropdowns for Google Sheets™ does not send spreadsheet cell values, source-table contents, selected ranges, or dropdown choices to Codeprint.

Codeprint receives only the account, installation, usage, entitlement, and billing information required to provide the Free and Pro plans.

The add-on requests access only to the current spreadsheet—not every spreadsheet in the user’s Google Drive.

GETTING STARTED

1. Install Dependent Dropdowns for Google Sheets™.
2. Open a spreadsheet.
3. Select Extensions → Dependent Dropdowns for Google Sheets™ → Open.
4. Choose Create configuration.
5. Follow the guided setup.
6. Test the connected dropdowns directly in the spreadsheet.

Setup guides and examples:
https://dependentdropdowns.com/guides
Yderligere oplysninger
PrisUden beregning med betalingsfunktioner
Dependent Dropdowns for Google Sheets™ anmoder om de tilladelser, der er angivet nedenfor. Få flere oplysninger
Dependent Dropdowns for Google Sheets™ har brug for adgang til din Google-konto
Dette giver Dependent Dropdowns for Google Sheets™ tilladelse til følgende:
Se og administrer regneark, som denne applikation er blevet installeret i
Vis og kør tredjepartswebindhold i meddelelser og sidebjælker i Google-apps
Tillad, at denne applikation kan køre, når du ikke er til stede
Opret forbindelse til en ekstern tjeneste
Se den primære mailadresse på din Google-konto
Se dine personlige oplysninger, heriblandt personlige oplysninger, som du har gjort offentligt tilgængelige
Knytte dig til dine personlige oplysninger på Google
Anmeldelser
Sprog:
Sorter efter:
Google verificerer ikke anmeldelser eller bedømmelser.Få flere oplysninger om anmeldelser
Ingen kommentarer
Søgning
Ryd søgning
Luk søgning
Google-apps
Hovedmenu