I need help with At Risk Formula

Staci Belonos

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))

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.