"How to add scores according to respondent's answer in a Likert scale?"- Google Docs Editors Community
A customer feedback form in Google Forms often asks how satisfied someone is on a five-step Likert scale, from Extremely satisfied to Extremely dissatisfied. To compare customers, each answer needs a number, 5 down to 1. A Google Forms quiz gives points only to a correct answer, so it can't score a scale where every answer counts, and 12 people on Google's forum have asked how to score by the answer picked. With Formfacade, the SCORE function in the Score question gives each answer its points, SCORE(entry#id, 5, 4, 3, 2, 1), and the score is worked out as each customer fills in the form.
Let's start. Import your Google Form and follow the steps below.
Turn your Likert scale answers into a score with SCORE.
Import your survey and replace POINTS() in the Score question with SCORE and the points for each answer. Each person is scored as they fill it in.