Turn Flag Red if Due Date is Past Today

Options

I am trying to turn my flag column red if my due date is past today. I am using

=IF(AND(Due Date]@row < +1<> "Complete"), 1, 0)

I am adding the formula to my Due Now column and getting Unparseable.

Please help! :)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!