Flagging Late Tasks

Options

Hi,


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!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!