Community

I have 15 questions using multiple choice, all with the same scoring. Yes +2 No 0 Unsure +1 I am using a Short answer to calculate the score. I am using this formula SCORE(ALL, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15) When I do preview and answer all 15 questions 'Yes', I expect the score to be 30. Instead the score is 17. I did it a second time and the score is 85. What have I done incorrectly?

James Christie

Aug 9, 2024

Comments (4)

Vipin

Aug 9, 2024

Hi James, you can use the SCORE(ALL, 2, 0, 1) formula to assign points and calculate the total score. The above formula will assign 2 points for the first answer choice, 0 for the second answer choice and 1 for the third answer choice for all multiple choice, checkboxes and grid questions. Please note that the above formula will also assign points for two multiple choice questions (number of employees, organization's readiness) in the first page. If you would like to assign points only for the questions in the second page, then add a short answer question in the second page with the SCORE(SECTION, 2, 0, 1) formula. This will assign points only for the 15 multiple choice questions in that section and calculate the score. I'd recommend you to use the Formfacade Assign points addon to add score calculations in your google forms. For detailed instructions, please refer to the links below. Calculate total score (add points for all questions the form) https://formfacade.com/calculate/assign-different-points-for-each-answer-in-multiple-choice-question-and-calculate-total-score.html Demo video https://youtu.be/zberDwRdLv8 Formfacade - Assign points addon https://workspace.google.com/marketplace/app/formfacade_assign_points/706030115252 You will have to use the Formfacade share link to collect responses. Otherwise, customization and score calculations will not work. When the user submits the form, you can view the responses along with the calculated scores in Formfacade Responses page as well as Google Forms. You can also sync responses to Google Sheets. Note: We have renamed the "Scorecery" addon as "Formfacade - Assign points" addon.

James Christie

Aug 13, 2024

How do I remove the statement This site belongs to James Christie.

Vipin

Aug 13, 2024

The footer cannot be removed, but you can update the footer text. Instructions below. Login to Formfacade. Click on the form to open it. Edit page will be displayed. In the Edit page, click on the profile name in the top right corner. Click Change theme. Theme settings page will be displayed in the Preview page. Click Page. Enter the required text in the Title (header / account name), Footer option (replaces "This site belongs to..."), upload the logo (replaces the default profile picture in the footer) and click Save.

James Christie

Aug 13, 2024

Perfect - thank you

Add your comment