Flag formula

JenS

I'm struggling with the flag formula even after reading these discussions and downloading the formula tools.

Goal is to:

Flag if status is not “complete” and due date in the past
Flag if status is blank and due date is less than or equal to 3 days from today

Current formula that works is below. I've tried adding to it without luck:

=IF(ISBLANK(End@row), "", IF(AND(End@row <= TODAY(), Status@row <> "Complete"), 1))

Columns are standard - start, end, status.

Find more posts tagged with

Formulas

Accepted answers

All comments

Michael Drayton

Hi @JenS

I modified your formula for your goals. I hope this helps:

=OR(AND([End Date]@row <= TODAY(), Status@row <> "Complete"), AND(ISBLANK(Status@row), [End Date]@row <= (TODAY() + 3)))

Let me know how it goes.

Good luck!

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.