Trying to count right answers

This is like grading student quizzes. We have some forms that get filled out. Sometimes there are multiple answers needed so we use multiselect checkboxes in the form. When we go to check the scores we can do all or nothing but we want to see if they got 3 out of 4 or 5 out of 7 or whatever.

hi @Joseph_Wheeler , did you consider countIf(currentvalue.contains(true())
something like that should work.
cheers, christiaan

Hey there! Hoping that this is what you are looking for. This would be a student quiz that asks “Which animals live in the ocean?”

In a table where you define your selections, I would create a second column that defines which answers are correct.

Then, create a column on the actual student answer database that filters their selection to find only the ones that are correct, then count them.

Let me know if you need any more help!

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.