Forum Discussion
Chris_Mancini
Nov 05, 2020Brass Contributor
MS Forms Weighted
We have various surveys that we send to client using an external survey provider. I am investigating the ability to satisfy our needs by using MS Forms. One requirement we have is the ability to have...
alexelizondo
Jun 16, 2021Copper Contributor
RobElliott I see you responded to this a while back. I am having some trouble with the weighted scores. I followed your instructions and did a weighted score for answers, for example, High Risk should equal 5, Medium Risk should equal 3 and so on. The information transfers to Excel from forms but it does not show the values, only the words like High Risk etc.
Not sure what to do at this point. I may be doing something wrong in the Switch section. I am using a Likert Scale question in Microsoft Forms.
Thanks in advance for your help!
ACLuser
Aug 23, 2022Copper Contributor
alexelizondo RobElliott I have the same concern, only the value is shown on the spreadsheet, not the score.