Skip to content

Euro 2020 Prediction Pool

Use this doc to run a prediction pool for Euro 2020 with your friends and family
This template is for a 2-stage pool.
- Participants will enter their predictions for group play before June 11.
- After group play ends, participants will enter their predictions for the knockout rounds.

If you want a full tournament prediction pool, check out .
Instructions
Copy this doc
Delete all predictions
in your new copy
Add yourself
to the and add your predicted total goals (used as tiebreaker).
Go to to add your predictions for group play.
As the game results come in, add the scores in “Team 1 Goals” and “Team 2 Goals” in .
(Optional) If you are the owner of this doc, and you want to enable email reminders for participants, make sure you (1) go to Explore > Packs & Import > Gmail to connect your email and (2) go to Settings > Automations > Email Updates and duplicate and turn on the rule. At the bottom, make sure the account is set to run using your own account (not Automation Bot).
After group play has finished, update Round of 16 teams in and fill in your predictions in .
Changelog
June 23 at 2:40pm PDT
Update “Teams” formula in
Update “Predictions” in
Update previous stage (hidden column) for Champion row in
June 15 at 7:20pm PDT
Add conditional formatting to “Prediction” column in
June 15 at 8:25am PDT
Update email subscription handling to send one email bcc’ing all recipients (avoid “too many requests” error)
June 13 at 12:15pm PDT
Summary: Update eliminated teams after each knockout match instead of after the knockout round is complete
Add “loser” column to
Update “eliminated teams” and “expected count” formulas in and add row for Round of 16
Update “was eliminated” column formula in
Hide “Points” column in
June 12 at 12:45pm PDT
Update “max possible points” column formula in
June 12 at 8am PDT
Update potential points formula in
Update conditional formatting for draws in
June 11 at 11:30pm PDT
Add “was eliminated” column to and update conditional formatting
Update “teams remaining” formula in
June 11 at 8:30pm PDT
Update email subject to include date
June 11 at 5pm PDT
Fix bug in leaderboard points formula
Update conditional formatting for leaderboard so that the leaders are green and everyone else is blue
“Add your predictions” button on will automatically add the user to the leaderboard
Scoring System
0
Email Updates
Fill out this form if you’d like email updates of current standings.
Email Frequency
No options available
Responses won't be saved because this doc is in play modeSubmit
Go to to unsubscribe or change your email subscription settings.
Leaderboard Chart
2
Leaderboard
2
Search
Person
Points
Max Possible Points
Predicted Champion
1
JB
James Booth
22
22
2
LT
Lola Tseudonym
22
22
3
PR
Polly Rose
21
21
4
JD
Joel Davis
20
20
5
BD
Buck Dubois
19
19
6
FM
Felix Marlin
19
19
There are no rows in this table

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.