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.
ScopeScoresExample
ALLAll the questions in the formSCORE(ALL, 1, 2, 3, 4, 5)
SECTIONAll the questions in the section. Your form needs more than one section.SCORE(SECTION, 1, 2, 0.5, 0.25, 0.25)
A questionOne question. Type @ and select it to add its entry id.SCORE(entry###, -1, -2, 0, 2, 1)
A search termThe questions whose description has the search termSCORE("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

Full article

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. Type POINTS(, 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)

Full article

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

Full article

Next steps