NOT "Complete" or "Not Applicable"

Reggie Andaya

Hi,

How would this be written to say NOT COMPLETE or Not Applicable?

=IF(AND([End Date]8 < TODAY(), NOT(Status8 = "Complete","Not Applicable"), 1, 0)

Find more posts tagged with

Accepted answers

All comments

Michael Culley

=IF(AND([End Date]8 < TODAY(), [status8]@row <> "Complete", [status8]@row <>"Not Applicable"), 1, 0)

Reggie Andaya

@Michael Culley Appreciate your help. Have a good weekend

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.