Hello,
I have a Google Form which will be used to register animals for a spay & neuter clinic. One of the questions is "Age".
I have multiple choices in Col A which include text. I want those choices to turn into numbers in Col B. I intend to report stats based on age groups in Col C.
1) Is there an easier way to set up the form so this gets calculated automatically? (English is a 2nd language here, so I can't rely on person entering too much)
2) Assuming no to #1 , I am bringing the responses into a Google Sheet where I can do formulas. What formula(s) do I use to get the responses from Col A into numbers like Col B?
Thanks, Andy
I have a Google Form which will be used to register animals for a spay & neuter clinic. One of the questions is "Age".
I have multiple choices in Col A which include text. I want those choices to turn into numbers in Col B. I intend to report stats based on age groups in Col C.
1) Is there an easier way to set up the form so this gets calculated automatically? (English is a 2nd language here, so I can't rely on person entering too much)
2) Assuming no to #1 , I am bringing the responses into a Google Sheet where I can do formulas. What formula(s) do I use to get the responses from Col A into numbers like Col B?
Thanks, Andy
Row/Col | A | B | C | |
1 | Choices | # result | Stats to calc on | |
2 | wanted | |||
3 | 1 month | 0.08 | 6 months or under | |
4 | 2 months | 0.17 | 6+ months to 1 year | |
5 | 3 months | 0.25 | 1+ to 2 years | |
6 | 4 months | 0.33 | 2+ to 3 years | |
7 | 5 months | 0.42 | 3+ to 4 years | |
8 | 6 months | 0.50 | 4+ to 5 years | |
9 | 7 months | 0.58 | 5+ to 6 years | |
10 | 8 months | 0.67 | 6+ or older | |
11 | 9 months | 0.75 | ||
12 | 10 months | 0.83 | ||
13 | 11 months | 0.92 | ||
14 | 1 year | 1.00 | ||
15 | 1+ year | 1.01 | ||
16 | 2+ years | 2.01 | ||
17 | 3+ years | 3.01 | ||
18 | 4+ years | 4.01 | ||
19 | 5+ years | 5.01 | ||
20 | 6 years or older |
| ||