Hi Richard, you can use the Scorecery addon to assign points and add score calculations in your google forms. If you would like to add the points for specific questions to calculate a category score, then please follow the instructions below.
Assign points, category
In the Scorecery Edit page, click on the gear icon next to the question (in the new editor, you will have to click on a question to select it and then click on the gear icon for that question) > Field settings page will be displayed > click Answer > assign the points for different answer choices > click Score category, enter the category name (For example: Communication) and click Save.
Calculate category score
In the Scorecery Edit page, click on the + icon to add a short answer question > enter the title "Communication score" > click on the gear icon for this question > Field settings page will be displayed > click Answer > enter the following formula POINTS(CATEGORY, "Communication") in the Calculate option and click Save.
Note: The formula for calculating the category score is POINTS(CATEGEORY, "category_name") where category_name is the category assigned for the questions. This is case sensitive; the name included in the formula must exactly match the name assigned for questions. You can calculate as many category scores as needed.
Scorecery demo video
https://youtu.be/zberDwRdLv8
Comments (1)
Mar 17, 2024
Hi Richard, you can use the Scorecery addon to assign points and add score calculations in your google forms. If you would like to add the points for specific questions to calculate a category score, then please follow the instructions below. Assign points, category In the Scorecery Edit page, click on the gear icon next to the question (in the new editor, you will have to click on a question to select it and then click on the gear icon for that question) > Field settings page will be displayed > click Answer > assign the points for different answer choices > click Score category, enter the category name (For example: Communication) and click Save. Calculate category score In the Scorecery Edit page, click on the + icon to add a short answer question > enter the title "Communication score" > click on the gear icon for this question > Field settings page will be displayed > click Answer > enter the following formula POINTS(CATEGORY, "Communication") in the Calculate option and click Save. Note: The formula for calculating the category score is POINTS(CATEGEORY, "category_name") where category_name is the category assigned for the questions. This is case sensitive; the name included in the formula must exactly match the name assigned for questions. You can calculate as many category scores as needed. Scorecery demo video https://youtu.be/zberDwRdLv8
Add your comment
Add photo