I need help with At Risk Formula

I am trying to have the at risk flag appear when the following conditions apply:

Status is : Comment Resolution, Not Started, Draft, NVX Review/ Comments

Due Date is less than 10 days away

I was playing around and got this far but its not working

=IF(OR(Status@row <> "Not Started", Status@row <> "Draft", Status@row <> "NVX Review/ Comments", Status@row <> "Comment Resolution"), 0, IF(AND([Due Date ]@row <=(Today)10, [Due Date]@row >=Today() 1, 0))

Find more posts tagged with

Formulas

Accepted answers

All comments

Staci Belonos

Snapshot for reference

Paul Newcome

What is the list of all of the possible statuses?

Staci Belonos

Comment Resolution, Not Started, Draft, NVX Review/ Comments

& Doc. Effective which obviously wouldn't apply

Paul Newcome

Ok. In that case we could just say "if the status is Doc. Effective" instead of "if the status is not one of these 4 things.

IF(AND([Due Date]@row <= TODAY(10), [Due Date]@row >= TODAY(), Status@row = "Doc. Effective"), 1)

Your original formula would still work except for a few syntax issues. It looks like you may have some extra spaces in some column names, a missing comma, and a few parenthesis need moved around.

=IF(OR(Status@row <> "Not Started", Status@row <> "Draft", Status@row <> "NVX Review/ Comments", Status@row <> "Comment Resolution"), 0, IF(AND([Due Date]@row <= TODAY(10), [Due Date]@row >= TODAY()), 1, 0))

Staci Belonos

Still not working

Paul Newcome

Which one is not working and is it outputting an error or an unexpected output?

The shorter formula above says:

IF Due Date is less than or equal to today + 10 AND Due Date is greater than or equal to today AND Status is not "Doc. Effective" then flag the row.

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.