Flagging Late Tasks



I am struggling to flag items as late. If Rounding Complete is not checked and the due date is greater then today I want to flag those items.

=IF(AND([Rounding Complete]@row, "1", [Date Rounding Scheduled]@row,<= TODAY()), "Red"))

Note sure where I am going wrong here.Thanks!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!