Blog · October 8, 2026

How to limit responses per option in Google Forms

Google Forms has no setting that says "this choice can be picked 10 times." If you run sign-ups, bookings or class places, you need a workaround. Here are three, from free and manual to set-and-forget.

What Google Forms can do on its own

Two settings come close, and neither is a per-choice limit:

• Accepting responses. On the Responses tab you can switch the whole form off. That closes every choice at once, not the one that's full.
• Limit to 1 response. In Settings, under Responses, this stops a signed-in person from answering twice. It doesn't stop ten people from picking the same time slot.

So if you want "Tuesday 3:00 pm" to disappear after one booking, or "Robotics club" to close at 20 students, you have to remove the choice yourself or let something remove it for you.

Option 1: close full choices by hand

This works for a small sign-up you can watch, like a 12-slot parent meeting list.

1. Open the form's Responses tab and click the green Sheets icon to send responses to a spreadsheet.
2. Check the responses sheet a few times a day. Sort or filter by the question's column to see what's taken.
3. When a choice reaches its limit, edit the question and delete that option.

It costs nothing, and it fails the moment you get busy. People keep picking a full slot until you get to it, and you end up emailing them to choose again. If more than a handful of people answer each day, use one of the next two options.

Option 2: sheet formulas and a populate add-on

This is the classic Form Ranger setup. A formula works out which choices are still open, and an add-on copies that list into the question.

Say your responses land in a tab called Form Responses 1, and the slot question's answers are in column B. Make a second tab called Slots:

Column C counts how many responses picked each slot. Column E lists only the slots where Taken is below Spots. Give E1 a header like "Open", then point a populate add-on at column E. Each time it syncs, the question gets the open slots only.

Things to watch with this setup:

• The text in column A must match the choice text exactly, or COUNTIF counts zero. A trailing space is enough to break it.
• For a checkbox question, one response can hold several choices in one cell. Use =COUNTIF('Form Responses 1'!B:B, "*"&A2&"*"), and avoid choices whose text sits inside another choice ("Room 1" and "Room 12").
• When every slot is taken, FILTER returns an error and the column is effectively empty. Some populate add-ons will then empty the question or fail without telling you. Wrap it as =IFERROR(FILTER(...), "All slots are taken") so there's always one value.
• If someone renames the header or a tab, the add-on can lose the column. See why Form Ranger lists go empty for the usual causes.

The formulas are free and you can see exactly how they work. The cost is upkeep: every new form needs the tab rebuilt, and the people who inherit it next year often don't know why it works.

Option 3: a choice eliminator add-on

A choice eliminator counts the responses itself and removes a choice when it's full. There are many in the Google Workspace Marketplace. We compare the main ones in choice eliminator add-ons compared. They differ in where the limits live: some ask you to type a limit next to each choice inside the add-on, others read limits from a sheet.

Our add-on, Audeza Choice Sync, does it from a sheet. Here is the setup:

1. Put the choices in one column of a Google Sheet. Optional: put each choice's limit in the next column (1 for a meeting slot, 12 for a workshop).
2. In the form, open Add-ons (the puzzle icon) > Audeza Choice Sync > Open, and click Link.
3. Pick the question, the spreadsheet and the column. The preview shows the exact choices before you save.
4. Turn on Remove a choice once it has been picked enough times. Leave the default of 1 per choice, or pick your limit column.

From then on it recounts the responses after every submission, every hour, and when you click Sync now. Delete a response and the slot opens again at the next sync. Responses you already have count too, so you can add it to a form that's already live. When every choice is taken, the question shows one placeholder choice, "All options are taken" by default, because Google Forms needs at least one. You can change that text.

It's free for 3 linked questions per form, with every feature on. If the sync fails, say because the column came up empty, the question keeps its last choices and you get an email explaining why. Details are in the setup guide.

Which option to pick

Limits every method shares

Some limits come from Google Forms itself, so no add-on gets around them:

• Simultaneous submits. A form doesn't reserve a choice while someone is filling it in. Two people who submit within the same few seconds can both get the last spot. It's rare, and you'll see both responses.
• Sheet edits aren't instant. Google doesn't let a Forms add-on watch a spreadsheet for edits. Changes in the sheet show up at the next sync, not the second you type.
• 1,000 choices per question. That's Google's cap for every question.

For a ready-made walk-through of the most common case, see time slot sign-ups in Google Forms or the parent-teacher conference guide.

Questions

Can Google Forms limit responses per choice without an add-on?

Not on its own. Google Forms can stop all responses or allow one response per signed-in person, but it can't count picks per choice. Without an add-on you close full choices by hand.

Can two people still get the last spot?

Yes, with any add-on, ours included. Google Forms doesn't hold a choice while someone fills in the form, so two people who submit at the same moment can both get it. The choice disappears a few seconds after the first response, so it's rare, and you can move one person afterwards.

Do limits work on grid questions?

A grid's rows or columns can be filled from a sheet, but per-choice limits only apply to dropdown, multiple choice and checkbox questions.

Is there a maximum number of choices?

Google Forms allows at most 1,000 choices per question, whatever tool fills them.