Dynamic choices guide

Google Forms dependent dropdown from Google Sheets

If by dependent dropdown you mean "Question B changes instantly based on the respondent's answer to Question A," Google Forms is limited. If you mean "keep dropdown choices aligned with a Google Sheets source list before people submit," FormRanger is a good fit.

Quick answer

Separate two different jobs

People use "dependent dropdown" to describe two different workflows. One is respondent-time filtering, where a later question changes based on an earlier answer. The other is spreadsheet-backed choice management, where the form owner updates choices from Sheets before the form is used.

Respondent-time dependent dropdown

Google Forms does not natively filter a dropdown from Sheets during a respondent's live session based on a previous answer.

Spreadsheet-backed choices

FormRanger can help keep dropdown, multiple-choice, and checkbox questions aligned with selected Google Sheets data.

Section branching

Google Forms can route respondents to sections based on answers, but that is not the same as a filtered Sheets-backed dropdown.

High-stakes availability

If options represent inventory, payments, or booking slots, use a buffer or a purpose-built system instead of relying only on a form choice list.

Best FormRanger fit

Use FormRanger when your team has one source list in Google Sheets and wants Google Forms choices to reflect that list after a controlled update.

  1. Keep the valid options in one clean Google Sheets column.
  2. Open the Google Form in edit mode and launch FormRanger.
  3. Select the source spreadsheet through Google Picker.
  4. Map one dropdown, multiple-choice, or checkbox question to the source column.
  5. Run Preflight, click Update now, then inspect the public form preview.
For the first run, test two values such as Alpha and Beta on a copied form. That makes it obvious whether the choices are coming from the selected sheet.

When to use another pattern

Need live filtering by previous answer?

Consider separate form sections, separate forms, Apps Script, or a form builder designed for conditional logic.

Need stock or seat locking?

Google Forms is not a transactional booking system. Add buffers, manual review, or a system that can reserve inventory.

Need only a rare list update?

Manual copy/paste may be enough if the list changes once a semester or once a year.

Need a maintainable list source?

Use FormRanger when the source of truth belongs in Sheets and the form should be refreshed from that source.

Do not promise respondents that a choice is still available solely because it appears in a Google Forms dropdown. Availability-sensitive workflows need extra safeguards.

Safe first-run test

  1. Duplicate the live form or create a test form.
  2. Add one dropdown question named "Test choice".
  3. Create a source sheet with one column and two obvious options.
  4. Install FormRanger, select the spreadsheet, and map the dropdown.
  5. Run Preflight, update the question, and open the public preview.

Related FormRanger guides