Help with status column formula

Emily Salter

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

Thanks!

BullandKhmer

Yeah

=IF([Due Date]@row="","",IF([% Complete]@row = 1, "Complete", IF([%Complete]@row = 0, "Not Started", IF([Due Date]@row < TODAY(), "Overdue","In Progress"))))

Emily Salter

Thank you but it is still saying #unparseable :(

Kelly Moore

@Emily Salter

Check the column name %Complete in the formula. One reference has a space, one does not. Correct the misspelling of whichever one does not match your sheet.