Combining Multiple IF Statements

I have combined multiple IF Statements into one formula but I am receiving an #UNPARSEABLE error. Please let me know where my mistake is in my formula. Thank you in advance for your help.

=IF([Status]@row=“Complete”,1,IF([Status]@row=“Not Started”,0,IF([Status]@row=“In Progress”,.25)))

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!