Responses are automatically added to the sheet
Form Responses. I want to apply certain formulas in a sheet called
Student Answers. However,
Student Answers doesn't auto-update from the submitted responses. Here are the formulas I am trying to use:
='Form Responses'!A1` etc. =IF('Form Responses'!E6='Answers'!$E$2,1,0)
Answers is another sheet with an answer key.
this sums the numbers given in the previous formula.
Basically, I have created a quiz, and I want to grade the quiz on a separate sheet.
Here is the Sheets in question.