At Risk Flag when Past Due and is not one of multiple status options (drop down)

I am trying to come up with function that raises flag if past the due date and status is not: 'CANCELLED', 'Customer Testing', 'Pending Sign Off', or ' SIGNED OFF'.

I have tried:

=IF(OR([Current Status]@row <> "CANCELLED", [Current Status]@row <> "Customer Testing, [Current Status]@row <> “Pending Sign Off”, [Current Status]@row <> “SIGNED OFF), 0, IF([Expected End Date]@row - TODAY() <= 7, 1, 0))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!