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
-
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.
-
This content has been removed.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!