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!
Karl