Making Overdue Tasks in project schedule

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

Find more posts tagged with

Accepted answers

All comments

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

Screenshot 2025-02-12 at 1.12.11 PM.png

Hope this helps! :)

Ipshita

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.