Create cascading dropdowns in Google Sheets™ without formulas or code. Parent choices automatically control the options shown in every following dropdown.
Listingan diperbarui:20 Agustus 2026
Berfungsi dengan:
Tidak ada ulasan
21
Ringkasan
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
Informasi tambahan
HargaTanpa biaya dengan fitur berbayar
Dependent Dropdowns for Google Sheets™ akan meminta agar izin ditampilkan di bawah ini. Pelajari lebih lanjut
Dependent Dropdowns for Google Sheets™ akan memerlukan akses ke Akun Google Anda
Hal ini akan mengizinkan Dependent Dropdowns for Google Sheets™ untuk:
Melihat dan mengelola spreadsheet tempat aplikasi ini dipasang
Menampilkan dan menjalankan konten web pihak ketiga pada perintah dan sidebar di dalam aplikasi Google
Mengizinkan aplikasi ini berjalan saat Anda sedang tidak ada
Menghubungkan ke layanan eksternal
Melihat alamat email Akun Google primer Anda
Melihat info pribadi Anda, termasuk info pribadi Anda yang tersedia untuk publik
Mengaitkan Anda dengan info pribadi Anda di Google
Ulasan
Bahasa:
Urutkan menurut:
Google tidak memverifikasi ulasan atau rating. Pelajari ulasan lebih lanjut
Tidak ada komentar
Telusuri
Hapus penelusuran
Tutup penelusuran
Aplikasi Google
Menu utama