Creating a test or assessment as a form

Kelly Parker

I am trying to create a test / exam / assessment in SS and create a formula to auto grade automatically. I created a column for the answer and a column to indicate if each column question is correct. The problem is when the user completes the test via the form, their response row falls below the answers, requiring me to copy down the answer. HELP

Andrée Starå

Hi Kelly,

Make sure thet you havee at least 2 rows before or after with the same formula structure and then it should work.

Did that work?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Sean_Sierra

What would the formula for this be?

Genevieve P.

Hi @Sean_Sierra

The exact formula and syntax will depend on how your specific sheet and assessment is set up.

You could use a nested IF statement to check each cell along the row to see if it houses the correct value. If you need help setting this up, it would be useful to see a screen capture of your sheet, but please block out sensitive data.

Cheers,

Genevieve