Turn Flag Red if Due Date is Past Today


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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!