Counting Past Due


I am trying to count anything that is a past due task, but not counting items that are closed. What is the best formula to use? 

My current formula:

=COUNTIF(Due:Due, <TODAY(1)) 

BUT this is counting all items that are due past TODAY. Any pointers?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!