Help! What am I doing wrong?

Hi - I hope this is an easy fix. I am trying to write a formula that will show "complete" when % Complete is 100%, "not started" when % complete is blank or 0 and "In progress" when it is anything else. The formula works when I split it apart but when I put it togetehr, I get "Unparseable". Thank you in advance.

=IF([% Complete]@row = 1, "Complete"), (IF(OR([% Complete]@row = "",[% Complete]@row= 0))), "Not Started", "In Progress")


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!