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



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!