Counting Past Due

bmcmichael48661

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?

Mike Wilday

=COUNTIFS(Due:Due, <TODAY(1), Status:Status, <>"Complete") 

That is assuming your status column is labeled Status and its not a checkbox column. If it is a checkbox column, try

=COUNTIFS(Due:Due, <TODAY(1), Status:Status, 0) 

bmcmichael48661

Mike- 

 

It is not supposed to count anything that is closed, lesson learned, or duplicate. 

The current formula is:

=COUNTIFS(Due:Due, <TODAY(), Disposition:Disposition, <>"Complete") 

This formula is counting those things, however, I need to count anything that is passed due and not closed, lesson learned or duplicate. 

 

Thoughts?

 

Branden 

J. Craig Williams

See also these posts:

https://community.smartsheet.com/discussion/countifs-formula-help-0

https://community.smartsheet.com/discussion/count-anything-passed-due-excluding-certain-criteria