Create cascading dropdowns in Google Sheets™ without formulas or code. Parent choices automatically control the options shown in every following dropdown.
Listelemenin güncellendiği tarih:20 Ağustos 2026
Şununla çalışır:
Yorum yok
21
Genel Bakış
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
Ek bilgi
FiyatlandırmaÜcretsiz (Ücretli özellikler vardır)
Geliştirici
Gizlilik politikası
Dependent Dropdowns for Google Sheets™ aşağıda gösterilen izinleri ister. Daha fazla bilgi
Dependent Dropdowns for Google Sheets™ uygulamasının Google hesabınıza erişmesi gerekir
Bu, Dependent Dropdowns for Google Sheets™ uygulamasının şunları yapmasına olanak tanır:
Bu uygulamanın yüklendiği e-tabloları görüntüleme ve yönetme
Google uygulamaları içindeki istemlerde ve kenar çubuklarında üçüncü taraf web içeriği gösterip çalıştırın
Siz yokken bu uygulamanın çalışmasına izin verin
Harici bir hizmete bağlanın
Birincil Google Hesabı e-posta adresinizi görme
Herkese açık olarak sunduklarınız da dahil olmak üzere kişisel bilgilerinizi görme
Sizi Google'daki kişisel bilgilerinizle ilişkilendirme
Yorumlar
Dil:
Sıralama ölçütü:
Google, yorumları ve verilen puanları doğrulamaz. Yorumlar hakkında daha fazla bilgi
Yorum yok
Arama
Aramayı temizle
Aramayı kapat
Google uygulamaları
Ana menü