Score function can be used to assign points to answer choices in multiple choice, checkboxes and grid questions and calculate the total score. Syntax: SCORE(scope, point-1, point-2, …, point-n) where
You can set the scope to ALL in the score function to assign points for all the questions in the form and calculate the overall score. Syntax: SCORE(ALL, point-1, point-2, point-3, …, point-n) Example usage: SCORE(ALL, 1, 2, 3, 4, 5) SCORE(ALL, 2, 3, 10, 8)
You can set the scope to SECTION in the score function to assign points for all the questions in the section and calculate the section score. Syntax: SCORE(SECTION, point-1, point-2, point-3, …, point-n) Example usage: SCORE(SECTION, 1, 2, 0.5, 0.25, 0.25) SCORE(SECTION, -1, -2, 0, 2, 1)
You can add the entry#id for a question as the scope to assign points for that specific question in the section and calculate the individual score for that question. Syntax: SCORE(question, point-1, point-2, point-3, …, point-n) Example usage: SCORE(entry###, 1, 2, 0.5, 0.25, 0.25) SCORE(entry###, -1, -2, 0, 2, 1) Note: Type @ and select the required question from the list to add its entry #id in the above formula.
You can add the search term as the scope to assign points for all the questions with description that has matching search term and calculate the score. Syntax: SCORE(search_term, point-1, point-2, point-3, …, point-n) Example usage: SCORE("Physical activity", 1, 2, 0.5, 0.25, 0.25) SCORE("Food & diet", -1, -2, 0, 2, 1)
Gridscore function can be used to assign points to the answer choices for specific rows in a grid question and calculate the score. Syntax: GRIDSCORE(question, rownum, point-1, point-2, … point-n) where
Click Submit to finish.
To use this feature, you need our Gsuite addon. Install this addon to calculate score.
Try It Free