Formula IF and NOT Validation

Mike Buckiewicz

I am trying to check a flag when two conditions are met:

End Date is past Today's Date
Status is NOT "Complete"

I am sturggling with this for some reason and cant see where I missed something:

=IF((TODAY() > End@row, NOT(Status@row = "Complete", 1,0)))

Any pointers would be helpful.

Find more posts tagged with

Formulas

Accepted answers

Mike Buckiewicz

After some serious tinkering I found an easier way for those that are wondering the result:

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

All comments

Mike Buckiewicz

After some serious tinkering I found an easier way for those that are wondering the result:

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

Genevieve P.

Hi Mike,

Thank you for sharing your solution!

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.