Counting Past Due

Options

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?

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!