Chapter 4 · Formulas
Score functions
Formfacade's score functions SCORE, GRIDSCORE and POINTS give answer choices points and add them into a score, per question, per section, or for the whole form.
Quick Answer
How do I calculate a score in Google Forms with a formula?
Set up Assign points, then write a score function in the Calculate option of the Score question. SCORE(scope, point-1, point-2, …) gives the answer choices their points, for example SCORE(ALL, 1, 2, 3, 4, 5) for every question. GRIDSCORE scores chosen rows of a grid question. Add scores together with +.
Score functions give points to answer choices and add them into a score. You write them in the Calculate option of the Score question that Formfacade adds when you set up Assign points. For the step-by-step scoring walkthroughs, see that page.
Where to write these functions?
Import your form for scoring
In Assign points, import your Google Form: paste its link or click Browse to pick it, then click Next.
Finish the setup
Under "Describe how you want to score this form", click Next. Under "How do you want to score?", click Next. On "You're all set!", click Preview form. Your form opens in a new tab.
Open the Edit tab
Back on the setup page, click Share form under Manage. Your form opens on the Share tab. Click the Edit tab.
Write the function
Click on the Score question, then click on the gear icon. Click Answer,
delete the POINTS() that is already in the Calculate option, write the
function and click Save.
SCORE
Assigns points to the answer choices in multiple choice, checkboxes and grid questions and calculates the total score.
SCORE(scope, point-1, point-2, …, point-n)
scope: which questions to score (see the table below).point-1, point-2, … point-n: the points for answer choices (a), (b), (c), (d), (e) and so on, in order.
| Scope | Scores | Example |
|---|---|---|
ALL | All the questions in the form | SCORE(ALL, 1, 2, 3, 4, 5) |
SECTION | All the questions in the section. Your form needs more than one section. | SCORE(SECTION, 1, 2, 0.5, 0.25, 0.25) |
| A question | One question. Type @ and select it to add its entry id. | SCORE(entry###, -1, -2, 0, 2, 1) |
| A search term | The questions whose description has the search term | SCORE("Physical activity", 1, 2, 0.5, 0.25, 0.25) |
With SCORE(ALL,1,2,3,4,5), a person who picks (e), (d) and (c) in three
questions scores 5 + 4 + 3 = 12. To give each question its own points, add a
SCORE for each question:
SCORE(entry#id, 1, 2, 3, 4, 5) + SCORE(entry#id, 2, 4, 6, 8, 10) + SCORE(entry#id, 5, 10, 15, 20, 25)
On a checkboxes question, SCORE adds up the points of every box ticked, and
points can be negative: SCORE(entry#id, 1, 2, 2, 10, -3, -5, -6, -1). On a
multiple choice grid, the points apply to every row: SCORE(entry#id, -1, 1, 0).
Full article
GRIDSCORE
Assigns points to the answer choices for chosen rows of a grid question and calculates the score. Your form needs a grid question for this.
GRIDSCORE(question, rownum, point-1, point-2, … point-n)
question: the entry id of the grid question. Type @ and select the question to add it.rownum: the rows to score.[2, 3, 5, 10]selects rows 2, 3, 5 and 10.point-1, point-2, … point-n: the points for the answer choices in the columns, in order from column 1.
GRIDSCORE(entry###, [2, 3, 7, 8], 1, 2, 3, 4, 5)
GRIDSCORE(entry###, [1, 4, 5, 6], -2, -1, 0, 2, 1)
To score some rows in reverse, add two GRIDSCORE functions. This happiness score is the average of 29 statements, 12 of them scored in reverse:
(GRIDSCORE(entry#id, [2, 3, 4, 7, 8, 9, 11, 12, 15, 16, 17, 18, 20, 21, 22, 25, 26], 1, 2, 3, 4, 5, 6) + GRIDSCORE(entry#id, [1, 5, 6, 10, 13, 14, 19, 23, 24, 27, 28, 29], 6, 5, 4, 3, 2, 1)) / 29
POINTS
When you set up scoring, the Score question's Calculate option already has
POINTS(). You can also point POINTS at part of the form:
POINTS(SECTION)adds up only that section's answers, with the points you set on each question. Add a Short answer question to each section and write it in its Calculate option.POINTS(question)adds up one question. TypePOINTS(, then type @ and select a question, then type). Type+and another POINTS for each question, to make a score for one category.
POINTS(SECTION)
POINTS(question_1) + POINTS(question_2) + POINTS(question_3)
Adding scores together
To add section scores into an overall score, use the SUM() formula in the Score
question, with each section score added with @. Or select the score for each
section with + between them:
section_1_score + section_2_score + section_3_score
You can also add the answers of linear scale questions directly. The P4 pain questionnaire adds four 0 to 10 answers into a score from 0 to 40:
pain_morning + pain_afternoon + pain_evening + pain_with_activity
Next steps
- Set up scoring step by step: Assign points.
- Show the score after submit: After submit.
- Write other formulas: Calculated fields.