How to assign points to answers selected thru drop down on form
Hello, I created a form to be used during a training exam. Each cell has a drop with 3 options, Proficient, Needs Improvement, Not covered. Is it possible to assign each option a point value ( 3  proficient, 2 Needs Improvement, 1 not covered) and have a total calculated once completed?
Thank you
Answers

Hi @BenD27
You could add a helper column to convert the choice to point.😀
Example:
=IF(Choice@row = "Proficient", 3, IF(Choice@row = "Needs Improvement", 2, IF(Choice@row = "Not covered", 1)))
Then, use the SUM to add up.
Example:
=SUM(Point:Point)

Thank you, does it matter that in the form I've created the columns are the questions not the rows? Each row will be a different learners name. In the image, test,test would be the name, then the scored columns follow. Where would I place the formula column in this set up?


@BenD27 try something like this.
=COUNTIF([Choice 1]@row:[Choice 10]@row, "Not covered") * 1 + COUNTIF([Choice 1]@row:[Choice 10]@row, "Needs Improvement") * 2 + COUNTIF([Choice 1]@row:[Choice 10]@row, "Proficient") * 3
Help Article Resources
Categories
Check out the Formula Handbook template!