Determine days overdue

I would like to have a column showing how many days overdue a task is using a due date column and a check box that indicates if the task is complete or incomplete.

I have tried the COUNTIF function but don't know if this works with a check box. See my columns below.


  • Nic Larsen
    Nic Larsen ✭✭✭✭✭✭

    Try something like this:

    =IF(AND([Task Complete]@row = 0, [Leads Due Date]@row < TODAY()), [Leads Due Date]@row - TODAY())

    Not knowing your task column name, you'd need to replace the one in mine.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!