# 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

Tags:

• ✭✭✭✭✭✭

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?

• ✭✭

@jmyzk_cloudsmart_jp any thoughts on the above question?

Thank you very much for your help.

• ✭✭✭✭✭✭

@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

• Achieve this using Google Forms in combination with Google Sheets. Use Data Validation in Google Sheets to create dropdowns and assign point values using IF or VLOOKUP formulas to calculate totals based on selected options.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!