Community
I created a linear scale form and set it to calculate specific values based on the response for each scale. However, it appears to be calculating the scale numbers rather than the assigned point values. For example, if someone answers Strongly Agree ("1" on the linear scale) they should receive a point value of 5. There are 20 questions, so someone who answers "Strongly Agree" for all questions should receive a final score of 100. However, the form is calculating that final score as 20.
Comments (2)
Oct 5, 2025
Hi Kiara, You have used the SUM function, which manually adds the numeric values of the answers in the formula. Please delete the existing formula and use the POINTS() formula instead in the Calculate option for the “Marks of a Disciple Quotient” question. When a user selects 1 as the answer for a linear scale question, the SUM function simply adds 1, instead of the 5 points you assigned to that answer choice. The POINTS() formula, on the other hand, automatically calculates the total score by adding the points assigned to each answer choice selected by the user.
Oct 5, 2025
Thank you! The form is now calculating correctly.
Add your comment
Add photo