Not FormRanger
Question B filters instantly while a respondent answers Question A.
Good FormRanger fit
Owner refreshes dropdown, checkbox, multiple-choice, or grid choices from Sheets before launch.
Decision guide
Dependent dropdown or synced choices?
These are different jobs. A State -> City -> Theatre dropdown chain needs live respondent-time filtering. FormRanger fits owner-controlled choice updates from Sheets before respondents use the form.
Quick answer
Google Forms cannot natively show a city dropdown from Sheets after a respondent chooses a state. Use FormRanger only when you need the form owner to refresh choice lists from Sheets before the form is shared.
For a State -> City -> Theatre form
The respondent chooses State, then the City dropdown instantly shows only cities in that state, then the Theatre dropdown instantly shows only theatres in that city.
Google Forms can route to sections based on a previous answer, but it does not provide a native spreadsheet-backed live filtering dropdown chain.
FormRanger can refresh separate owner-controlled choice lists from Sheets, such as a State list or a Theatre list, before respondents use the form.
FormRanger does not filter City choices live after each respondent chooses a State. That needs branching, Apps Script, AppSheet, or another form experience.
Safe FormRanger path
Put valid choices in one clean Sheets column.
Connect a supported form choice question to the source column.
Update choices, then check the public form preview.
Choose another pattern when needed
Use sections, separate forms, Apps Script, AppSheet, or a form tool built for conditional dropdowns.
Use buffers, manual review, or a system that can reserve availability.
Dependent dropdown vs Sheets choice sync
Respondent picks one answer and the next question changes immediately. This is conditional logic, not a spreadsheet refresh.
Form owner refreshes choices from a selected Sheets column before respondents use the form. This is where FormRanger fits.
Examples that look similar but need different setups
If the respondent chooses a department and the manager dropdown must change instantly, use sections, branching, Apps Script, or a form product built for live conditional choices.
If the owner keeps a Sheet of available sessions and refreshes the form before sharing it, use FormRanger to sync that Sheet column into the dropdown.
If each respondent must see cities filtered by region at answer time, FormRanger is not the core logic. It can still help maintain static region or city lists before launch.
If choices only need to change between launches or before a weekly form goes out, spreadsheet-backed choice sync is usually simpler than custom conditional code.
Next step
FAQ
Can Google Forms make a live dependent dropdown from Sheets?
Not natively. Google Forms does not provide respondent-time filtering from a Sheets range.
Can I build State -> City -> Theatre dropdowns from one Sheet?
Not as a native live dropdown chain in Google Forms. You can use section routing for simple branching, or use Apps Script, AppSheet, or a different form tool for live filtering.
What can FormRanger help with?
It can update supported Google Forms choice questions from selected Sheets data before respondents use the form. It is useful for owner-controlled choice refreshes, not respondent-time filtering.
What should I test first?
Use one copied form, one question, and two sheet values such as Alpha and Beta.