Formula Help

Hello,

Can someone see what im doing wrong with this formula please?

=IF([Q1: Navigation around site and accessing document]@row = "Not Applicable", 0, (IF([Q1: Question 1 ]@row = "Did not meet expectations", 1, (IF([Q1: Question 1]@row = "Partially met expectations", 2, (IF([Q1: Question 1]@row = "Met expectations", 3,)))))))

Thanks!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!