Making Overdue Tasks in project schedule

tim_sims23

Hello all,

I am trying to label a task as overdue when the planned end date is in the past and if the task is not marked in progress, Not Started or complete. This is my formula but its not running properly. Any advice would be appreciated.

=IF([Status]@row =, "Complete", IF([Status]@row =, "Not Started" , IF([Status]@row =, "In Progress", IF(AND([Planned End Date]@row <= TODAY()), "Overdue")

Ipshita

Hello @tim_sims23 Here's the formula help for you with a screenshot of the example -

=IF(AND([Planned End Date]@row < TODAY(), NOT(OR([Status]@row = "Complete", [Status]@row = "In Progress", [Status]@row = "Not Started"))), "Overdue", "")

Hope this helps! :)

Ipshita