CountIf Help

edited 12/09/19 in Formulas and Functions

Is there a formula that would count the number of cells where a Done check is not completed but only when another columns due date is in the past?


The goal is to count how many past due tasks I have.  Does anyone know the best way to accomplish this?





  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    =countifs([Done Check Column Name]:[Done Check Column Name], 0, [Due Date Column Name]:[Due Date Column Name], >Today()) 

    Should give you a count of everything that is not checked and is in the past. 

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!