How to track items that are completed after their due date

Tiffany White
Tiffany White ✭✭✭
edited 12/09/19 in Formulas and Functions


I'm trying to track tasks that are completed after the due date. I used this formula to indicate when an task was past due and not complete but once the task is checked off as complete it no longer works, well it works it just doesn't give me the data I'm looking for. 

=IF(AND(TODAY() = DUE5 + 1, Done5 = 0), 1, 0)

I'm trying to keep away from having staff enter the date they completed the task but am not sure how to do this.

Does anyone know a formula that I could use to indicate if a task went past due before being complete? Any help would be appreciated!

Thank you!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!