IF with multiple choices dropdown list cell


Hello everyone!

English is a second language for me so please forgive my spelling mistakes in advance.

I have a form with a multiple choice dropdown that populates one of my columns in my sheet. I want to do an IF to give a rating based on the answers.

Here's what I got:

=IF([Question]@row = "answer1" and "answer2"); 0; IF([Question]@row = "answer1" and "answer3"; 0,5; IF([Question]@row = "answer1"; 1)))

I would like to add a ELSE like in VBA for the remaining combinations. Also the AND function doesn't work like that in Smartsheet, so I'm not sure how I should do it.

Thank you for your help!



Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!