Help with status column formula


Hello, I have created a formula to show the status as not started, in progress or complete when the %complete column is changed.

This is the formula

=IF(OR(ISBLANK([Due Date]@row)), “”, IF([% Complete]@row = 1, “Complete”, IF(AND([Due Date]@row < TODAY()), “Overdue”, IF([%Complete]@row = “0”, “Not Started”, IF([%Complete]@row = “1”, “Complete”, IF([%Complete]@row = “”, ””, ”In Progress”))))))

Please can anyone let me know what is incorrect as I am getting #unparseable



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!