Help! What am I doing wrong?

lisamurzyn

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")

Paul Newcome

You have some parenthesis issues. Try this:

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

lisamurzyn

Oh thank you so much. I figured it was something simple, I really appreciate the quick and correct response. :-) Have a wonderful day!!!

Paul Newcome

Happy to help. 👍️