Forum Discussion
Forms total points column content missing in excel
Hi all, I have used Forms now for many months and used to check the quiz results by downloading excel sheet. Everything has worked fine till last week: on downloaded excel the total points column...
Thank you for your replyAndrew Young ,
I was wondering the same issue, but there is only 580 responses on my quiz so perhaps that´s not the issue or what do you think?
I've tested with as little as 5 responses and the still the points don't show. So there must be an issue with MS FORMS from there end.
- Ok, what can I do next? Any suggestions?
I don't know if there is a way we can report this to microsoft or MS FORMS admin or something.
As a work around, I completed the quiz with all the questions answered correctly and then added an 'IF' function in the points column to check against the correct answer, if correct return a '1' if not a '0'.
Finally added a sum function in the total points column to added them all up.
Shouldn't have to do it and its a pain but its a workaround until they fix it. Depending on how many questions you have this is either a minor task or a major one.