Formula to flag overdue Items with 2 conditions

I am currently using this formula to indicate if a task is overdue (via a flag).

=IF(AND(NOT(ISBLANK([End Date]@row)), [End Date]@row < TODAY()), 1, 0)

I just realized that the Overdue flag is still red when the Status is 'Complete.' How do I add this into my formula? Tried to add NOT(Status@row= "Complete") but I'm either not putting it in the formula correctly or it's not the appropriate one to add.

Thanks in advance for your help!

Find more posts tagged with

Accepted answers

Paul Newcome

Try this...

=IF(AND([End Date]@row <> "", [End Date]@row < TODAY(), Status@row <> "Complete"), 1, 0)

All comments

Paul Newcome

Try this...

=IF(AND([End Date]@row <> "", [End Date]@row < TODAY(), Status@row <> "Complete"), 1, 0)

Jen Garijanian

Thank you!

Paul Newcome

Happy to help. 👍️

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.