Forum Discussion
Assigning a numerical value to answers for overall scoring - Employee reviews
StaWM I don't think there is any sensible way to do this with Forms, but it is very easy with a flow in Power Automate to then save the result to a list in SharePoint.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
RobElliott Could you explain how to do this? I have never used Power Automate but do want to add the results to a SharePoint list and be able to count the N/A selection in a way that does not take away points but rather distributes the points left between the other choices.
i.e., If I have ten questions, each with a 1-point value. In an eval, if I get 9 "Yes" and 1 "N/A", the final score desired would still be 10 - (9 out of 9 correct answers).
I now get nine since I have the "Yes" marked as the correct answer. I tried check-marking the "N/A" as a second right answer, although that inflates the score, and I rather not.
vrhoades sorry I don't understand this, what do you mean by "distributes the points left between the other choices"?
RobElliott Hi Rob, here is a visual in Excel of what I am trying to do in Forms. When NA is used, it removes the number of questions scored, therefore reducing the denominator. However, in forms, it counts NA as a question regardless, and it counts it as an incorrect answer since I can only say that YES is the correct answer.
Thank you for taking the time to look at this. I appreciate it.