How to Set Up Ranked Choice Voting in Google Forms (and Tally the Results)

Google Forms doesn't have a real ranked-choice question type.

There's a workaround using the Multiple Choice Grid, and there's a second workaround using a separate question for each rank. Both work for a quick team vote; neither scales past about 50 voters or 5 candidates without spreadsheet pain.

This guide shows both methods step by step, a worked tally example in Google Sheets (4 candidates, 18 voters, 3 elimination rounds), and where Formester's drag-and-drop Ranking field cleans up the parts Google Forms gets wrong: no duplicate-rank trap, no Google sign-in required, and a built-in response summary chart.

Ranked-choice voting is now used by nearly 14 million people across 51 U.S. jurisdictions, with over 800 elections held since 2004, so the workflow matters. The walkthrough below is the same one we use internally for Formester team decisions.

How Ranked Choice Voting Works?

Each voter ranks every option from most preferred to least preferred (1st, 2nd, 3rd, and so on). Counting happens in rounds.

1. Round 1: count every voter's first choice. If any option has more than 50%, it wins. Stop.

2. If nobody clears 50%, the option with the fewest first-choice votes is eliminated.

3. Every ballot that ranked the eliminated option first gets recounted using its second choice.

4. Repeat rounds until one option crosses 50% or only two options remain.

The two practical consequences: a candidate can lead Round 1 and still lose, and a ballot that doesn't rank enough options eventually "exhausts" out of the count. Both happen in real elections; both will happen in your team vote at scale.

Why Use Ranked Choice Voting?

• No wasted votes. A ballot for the eliminated last-place candidate still counts because it transfers to that voter's second pick.

• Stronger consensus. The winner has majority support after transfers, not a 27% plurality in a 5-way split.

• Less strategic voting. Voters can rank their honest favorite first without "throwing away" the ballot if that favorite is unpopular.

Where RCV is overkill: a 2-option vote (a standard yes/no), or a 30-second team poll where rough consensus is fine. Use it when the choice matters and there are 3+ real contenders.

Where Teams Actually Use Ranked Choice Voting

• Engineering team picking the next quarter's roadmap initiative from 6 candidates.

• Marketing team voting on the next event sponsorship from 4 options.

• HR running an employee award where 5 nominees each have a fanbase.

• Community board selecting a new logo from designer submissions.

• Student council elections (the original RCV use case, still the cleanest fit).

If your "vote" has only 2 options or one is the obvious favorite to 80% of voters, skip RCV; a Google Forms multiple-choice question is fine.

How to Use Google Forms and Sheets for Ranked Choice Voting (RCV)

Method 1: Multiple Choice Grid (the most common Google Forms workaround)

This is the method most teams use. One question, every candidate is a row, every rank is a column.

Step 1. Define the decision. Name the choice, the candidates, and who can vote. Lock the candidate list before sharing; adding a candidate mid-vote invalidates earlier ballots.

Step 2. Open a blank form at forms.google.com. Add a title and a one-line description explaining the rules ("rank every option once; do not skip ranks").

Step 3. Add a Multiple Choice Grid question.

• Rows: each candidate (Candidate A, Candidate B, Candidate C, Candidate D).
• Columns: each rank (1st choice, 2nd choice, 3rd choice, 4th choice).
• Toggle on Require a response in each row. Without this, voters can submit half-ranked ballots that exhaust early in the tally.
• Toggle on Limit to one response per column. This is the single most-missed setting. Without it, a voter can rank three candidates as their 1st choice; the ballot is unscorable.

Step 4. Add a short instruction at the top of the form:

Rank each option once. Don't reuse a rank. Don't skip ranks.

Step 5. Share. Use the form's link in Slack, email, or a QR code. For team votes where attribution matters, leave "Collect email addresses" on; for community votes where anonymity matters, turn it off (and note: turning it off means the form is open to ballot stuffing unless you also add a passcode question).

When to use this method: 3-5 candidates, fewer than 50 voters, one-off vote. When NOT to use it: 6+ candidates (the grid gets unreadable on mobile), 50+ voters (manual tally takes hours), or a recurring vote where you'd benefit from a real Ranking field.

Method 2 alt (call out below the grid steps):

A second workaround is to use a separate Multiple Choice question for each rank (one question per rank, candidates as options, "Limit to one response" per option enforced via Google Forms validation). It's slower to fill out but easier for voters to understand. Use it if the grid is visually overwhelming on mobile.

Examples of RCV in Action

• Leadership selection: Teams can pick leaders that everyone supports.

• Work prioritization: Focus on tasks that matter most to the group.

• Awards and contests: Ensure the best entry wins fairly.

RCV helps make better decisions, respects everyone’s voice, and finds solutions with broad support.

Common Ranked-Choice Voting Mistakes (and How to Avoid Them)

• Letting voters reuse a rank. A ballot with two "1st choices" is unscorable. Fix: turn on "Limit to one response per column" in Google Forms, or use Formester's Ranking field (enforced by design).

• No clear winning threshold. Without 50%+1, you can land on a "plurality winner" by accident, which defeats the point of RCV. Fix: state the threshold in the form description.

• Adding a candidate mid-vote. Earlier ballots can't rank a candidate they never saw. Fix: lock the candidate list before sharing the link.

• Ignoring exhausted ballots. If voters can rank fewer than all candidates, plan for exhaustion in your tally rules. Fix: either require ranking every option (Google Forms: "Require a response in each row") or document how exhausted ballots are handled.

• Tie-handling left to the moment. Decide tie rules before the vote runs. Coin-flip ties are fine if announced; surprise coin-flip ties are not.

• Manual tally past 50 ballots. Past about 50 ballots and 4 candidates, the manual rounds become error-prone. Switch to one of the tally tools listed above.

How to Create a Ranked Choice Voting Form in Formester?

Google Forms' grid is a stand-in for a ranking question; Formester ships a proper Ranking field. The difference matters for two reasons: voters can't accidentally pick the same rank twice (the field enforces unique ordering), and the response view shows a distribution chart per option instead of a raw grid.

Step 1. Log in to Formester and start a new form. Pick "Blank" or the Poll Maker template.

Step 2. Add a Ranking field. Click the field menu, pick "Ranking," and list your candidates as the options. Voters drag-and-drop options into preference order, or click to rank.

Step 3. Add a description, for example: "Rank each option from most preferred to least preferred. Every position must be filled."

Step 4. (Optional) Add brand styling. Logo, brand colors, and custom subdomain on Personal plan and above, via the branding kit. Useful for community votes where the form represents an organization.

Step 5. Share via link, embed, or QR code. Formester forms don't require a Google account to respond, which is the deciding factor for any vote with external participants (community boards, customer councils, public elections).

Step 6. Review responses. Each option gets a summary distribution chart showing how many voters ranked it 1st, 2nd, 3rd, and so on. This is the fastest way to see the shape of the vote before you do the round-by-round tally.

Honest caveat: Formester does not auto-tally ranked-choice voting (round-by-round elimination is still a Google Sheets job, same as Google Forms). What Formester saves you is the data-capture mess: clean ordered preferences instead of grid cells you have to parse for duplicates.

Conclusion

For a small team vote, Google Forms' Multiple Choice Grid plus a Google Sheets tally is enough. For anything where voters expect a real ranking field, no Google sign-in, and a clean summary view, start a free Formester form or grab the Poll Maker template.