CountIf Help
Options
ggross
✭
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?
Tags:
Comments
-
=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
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!