Determining Exact Match for Multiple Criteria in a Multiple Selection Dropdown
I am trying to grade a quiz where the answers were submitted via a smartsheet form. I am having trouble figuring out how to confirm that there is an exact match on questions that had multiple answers needing to be selected to be considered correct.
On questions that only use one answer, this is the formula I use:
=IF(HAS([Question 1]1, "The Correct Answer"), 1, 0)
Is it possible to modify this formula to get confirmation that multiple correct dropdown options were selected?
Best Answer
-
Yes, you could build the exact criteria you need in the formula. It looks like each column is a question and I assume the rows are students. You could put the correct answer in the first row and simply use
=IF([Question #]@row=[Question #]$1, 1, 0)
This would check to see if the response is an exact match of the answer you indicate in the first row.
👨🏼💻 Dan Palenchar | School of Sheets Solutions Consulting | Smartsheet Aligned Gold Partner
If this helped, help me & the SSC by accepting and reacting w/ 💡insightful, ⬆️ Vote Up, and/or ❤️Awesome!
- 🆘 Smartsheet Consulting Inquiries: schoolofsheets.com/workwithus
- ▶️ Smartsheet Tutorial Videos: schoolofsheets.com/youtube
PS - If you have a follow up response tag me @SoS | Dan Palenchar so I get notified of your reply!
Answers
-
Yes, you could build the exact criteria you need in the formula. It looks like each column is a question and I assume the rows are students. You could put the correct answer in the first row and simply use
=IF([Question #]@row=[Question #]$1, 1, 0)
This would check to see if the response is an exact match of the answer you indicate in the first row.
👨🏼💻 Dan Palenchar | School of Sheets Solutions Consulting | Smartsheet Aligned Gold Partner
If this helped, help me & the SSC by accepting and reacting w/ 💡insightful, ⬆️ Vote Up, and/or ❤️Awesome!
- 🆘 Smartsheet Consulting Inquiries: schoolofsheets.com/workwithus
- ▶️ Smartsheet Tutorial Videos: schoolofsheets.com/youtube
PS - If you have a follow up response tag me @SoS | Dan Palenchar so I get notified of your reply!
-
Thank you, that worked!
Help Article Resources
Categories
Check out the Formula Handbook template!