Return true or false for multiple selection question

Options
YJ Li
YJ Li ✭✭
edited 06/22/22 in Formulas and Functions

Hi,

I have some multiple selection questions to grade and not sure what formula to use.

So there are A,B,C,D,X for the selection and the correct answer is A,C.

I want a true response for people who select A&C only, any other types of combination needs to return as false.

I tried AND formula, but it return as true even when people select A,C,D or any combinations that contains A&C. So it did not work out for what I was looking for.

Any suggestions? Thanks!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!