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

Tags:

• Snapshot for reference

• ✭✭✭✭✭✭

What is the list of all of the possible statuses?

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

& Doc. Effective which obviously wouldn't apply

• ✭✭✭✭✭✭

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

• Still not working

• ✭✭✭✭✭✭

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.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!