Hoping to get some assistance.
I have a survey where I need to assign a score to each select_one choice and provide a total at the end of the survey.
a calculation is straightforward except when I have 2 or more choices with the same score, in the same category.
in the form if 1 is selected, naturally it checks both pear and apple as a choice, which is not what I want. :)
interestingly though, the calculation only calculates the 1 choice, not both apple and pear.
At the moment I have the score in the name column of the choices sheet. Is there anyway to calculate the label?
I'm sure this is something simple that i've missed. :)