Compiling a checkbox form to a spreadsheet

Hey so I have a client that wanted me to create a form that has four options for each question for example
1.) Morning is when I feel best
A little of the time
Some of the time
Good part of the time
Most of the time
Each answer is supposed to have a number correlated with it i.e:
A little of the time = 1
Some of the time = 2
Good part of the time = 3
Most of the time = 4
These numbers are supposed to be added up and calculated to have a total number. How do I make it so that each response checked is added up when the response is marked? I know the form needs to be connected to a spreadsheet, which it is, but every time I fill out the form, the responses added to the spreadsheet are the same responses that I placed in the form. I want to correspond these answers to numbers that can be added up in a spreadsheet.
Any help on this subject would be awesome!!!

without having looked at the sheet
can only take assumption in what your trying to do
i think your transferring to spreadsheet maybe the issue
you are somehow taking the caption instead of value?

Please Login or Register  to view this content.

whereby
checkbox1 = first answer
A1 = destination cell
extrapolate this for all 4

Also assume you should only have one answer so suggest using Option button (with groupbox) instead of checkbox
alternatively use a combo box and
use select Case

Select Case [form name] (whatever the form control is)
Case " answer 1"
Range("a1") = 1

case "answer 2"
Range "A1" = 2

...etc

end select

hmmm Google excel ....not the form i was expecting
thought you were doing VBA

anyway first thing to change
question should be multiple choice not checkboxes
checkboxes means you can select all 4 options for every question. Judging by the questions....this is not what you want

after this you will need to code responses with either a table conversion or something of that nature to covert text response to numbers

Alternatively
have you looked into using scale option
its not exactly what you were initially after but believe its a better fit to how do you feel kind of questions

the responses that they give coincides with a number and that number is recorded onto your spreadsheet
https://docs.google.com/forms/d/1IOp...jnt7U/viewform