Using IF, AND, OR

Looking for formula advice/help! I would like to write a formula that will:

Mark Past Due if Complete By is greater than today + task is not complete
If no Complete By date exists, than Past Due flag remains unchecked

So far, I've been able to create a flag based on the first bullet, however-- tasks that do not have a Complete By date associated show as flagged. Would I use an OR in this situation? Not even sure if this is possible-- Any thoughts?

Find more posts tagged with

Formulas

functionality

Accepted answers

@SPark

I've figured it out! I tried to go back and remove my question but it won't let me delete. 🤔Here is what I used..

=IF(ISBLANK([Complete By]@row), 0, IF(AND([Complete By]@row < TODAY(), [Task Complete]@row = 0), 1))

Genevieve P.

Hi @SPark

So glad to hear your figured it out! Thanks for posting your resolution - this could be useful to others so we'll leave your post up, if that's alright with you.

Cheers,

Genevieve

All comments

@SPark

I've figured it out! I tried to go back and remove my question but it won't let me delete. 🤔Here is what I used..

=IF(ISBLANK([Complete By]@row), 0, IF(AND([Complete By]@row < TODAY(), [Task Complete]@row = 0), 1))

Genevieve P.

Hi @SPark

So glad to hear your figured it out! Thanks for posting your resolution - this could be useful to others so we'll leave your post up, if that's alright with you.

Cheers,

Genevieve

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.