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
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!