To make a quiz with scores in Notion, build a form whose questions are multiple choice, then add a formula property to the form’s database. The formula compares each answer with the correct option and adds a point when they match, so every response row gets its Notion quiz score the moment it lands.
Notion has no quiz mode, so the database does the grading.
How a Notion quiz score works
A Notion quiz score is a formula property on the database behind your form. Each form submission becomes one row, each question is one property on that row, and the formula reads those properties and returns a number.
Notion’s forms help page says a form’s question type “is the equivalent of the property type”. A multiple choice question is a select property, and that’s what makes scoring possible: a select value is plain text the formula can compare.
Step 1: build the quiz form
Build the quiz as a normal Notion form, with one multiple choice question per quiz item.
- Create a database and add a Form view.
- Add each question and set its type to Multiple choice.
- Type the options. Keep the correct option’s wording short and exact, because the formula has to match it.
- Mark every question Required, so a blank answer can’t slip through as a silent zero.
- For “pick all that apply” items, use a multi-select question. Notion lets you cap the number of selections per response for those.
Add a short text question for the respondent’s name if the form is public. Web-link forms are anonymous, and the Respondent property only fills for workspace forms.
Step 2: add the scoring formula
The scoring formula gives each question a 1 or a 0 and adds them up. Add a new property to the database, set its type to Formula, name it Score, and paste a formula like this:
sum(
if(prop("Capital of France") == "Paris", 1, 0),
if(prop("Largest planet") == "Jupiter", 1, 0),
if(prop("Author of Hamlet") == "Shakespeare", 1, 0)
)Every part comes straight from Notion’s formula syntax page. A select property is compared with ==, as in its example prop("Priority") == "High". The if function returns its first value when the condition is true and the second when it’s false. The sum function adds its arguments, so sum(1, 2, 3) gives 6.
Swap in your own property names and correct answers. Property names go inside prop("...") exactly as they appear in the database.
Scoring multi-select questions
A multi-select question should score a point only when the respondent picks every correct option and nothing else. Checking for one right answer isn’t enough, because someone who ticks every box would include it too.
Notion’s formula page shows that a multi-select returns a list, with .length() and .includes() available on it. Combine them:
if(
prop("Prime numbers").includes("2") and
prop("Prime numbers").includes("3") and
prop("Prime numbers").length() == 2,
1, 0
)Drop that if(...) into the sum(...) list as one more item.
Turning the score into a grade or pass mark
A second formula can turn the number into a label. Notion’s ifs function returns the value for the first true condition, which saves you from nesting if calls.
ifs(
prop("Score") == 4, "Perfect",
prop("Score") >= 3, "Pass",
"Retake"
)Name it Result, then group or filter a table view by it. A teacher marking a weekly vocab check can open a “Retake” view on Monday and see exactly who needs another go.
Mistakes that break the score
Most broken Notion quiz formulas come down to text that doesn’t match. A select comparison is exact, so these all return 0:
- Renamed options. Fixing a typo in an option name doesn’t update the formula text.
- Extra characters. “Paris “ with a trailing space is not “Paris”.
- Wrong property name. A question renamed in the form builder renames the property too, and
prop()then points at nothing. - Missing questions. Adding a quiz item without adding its
ifline means it’s never counted.
Test the form yourself twice before you share it: once with every right answer, once with every wrong one. You should see the full score and then 0.
What a Notion quiz can’t do
The main limit is that respondents never see their score. Notion’s submit screen settings cover the button colour and text, a confirmation title and body, and an email copy of each submission. Nothing there can display a formula result.
Workspace forms can give respondents Can view access to their submission, but that opens the response page, not a results screen. Think about whether the Score property should be visible there before you switch it on.
There’s also no timer, no per-answer feedback and no shuffling. Branching to different questions needs conditional logic, which Notion limits to Business and Enterprise plans.
My take: for internal checks, like onboarding quizzes or a class’s weekly test, use this native setup. You read the scores, the respondents don’t need instant feedback, and everything stays in one database. If people expect to see “You scored 4 out of 5” on screen, you’ll need another tool or a manual follow-up.
Scoring nDBForms responses with the same formula
nDBForms writes each submission as a new row in your Notion database, and its select, multi-select and yes/no questions map to the matching Notion property types. The same Score and Result formulas grade those rows unchanged.
That helps when you want a branded quiz page or need branching without a Business plan, since nDBForms offers logic rules on its Pro plan. The scoring still happens in Notion. Browse the form templates for a starting layout.
For related set-ups, see how to create a form in Notion, how conditional logic works in Notion forms, and the assignment submission form guide. If a score shows 0 because the answer landed in the wrong property, the field mapping guide explains why.
FAQ
Does Notion have a built-in quiz feature?
No. Notion forms collect answers into a database, and a formula property does the scoring. Notion’s help pages describe no quiz mode or answer key setting.
Can respondents see their score after submitting a Notion form?
Not on the submit screen. Notion’s submit screen settings cover the button, a confirmation title and body, and an email copy, with no way to show a calculated score.
How do I score a question with more than one correct answer?
Use a multi-select question and check that every correct option is included and the number of picks matches, so a respondent who ticks everything gets no point.
Why does my formula give zero for a correct answer?
The text in the formula must match the option name exactly. A renamed option, a trailing space or different capitalisation makes the comparison false.