Create cascading dropdowns in Google Sheets™ without formulas or code. Parent choices automatically control the options shown in every following dropdown.
정보 업데이트:2026년 8월 20일
호환 기기:
리뷰 없음
21
개요
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
추가정보
가격유료 기능을 포함한 무료
개인정보처리방침
Dependent Dropdowns for Google Sheets™에서 아래에 표시된 권한을 요청합니다. 자세히 알아보기
Dependent Dropdowns for Google Sheets™에서 Google 계정에 액세스해야 함
이렇게 하면 Dependent Dropdowns for Google Sheets™에서 다음 작업을 할 수 있습니다.
애플리케이션 설치 시 사용한 스프레드시트 조회 및 관리
Google 애플리케이션 내 메시지 및 사이드바에 외부 웹 콘텐츠를 표시하고 실행합니다.
부재중에 이 애플리케이션을 실행하도록 허용
외부 서비스에 연결
기본 Google 계정의 이메일 주소 확인
개인정보(공개로 설정한 개인정보 포함) 보기
Google에서 내 개인 정보를 나와 연결
리뷰
언어:
정렬 기준:
Google에서는 리뷰나 평점을 확인하지 않습니다. 리뷰에 대해 자세히 알아보기
댓글 없음
검색
검색어 지우기
검색 닫기
Google 앱
기본 메뉴