Count Past Due and Coming Due Items

Bryan Dillon

I would like to count past due and coming due items. 

 

For Past Due, I have a variance column that I have been able to use  =COUNTIF(Variance2:Variance31, >0). The issue I have is that it is also counting completed tasks that had a variance but have since been checked off as done. Is there a way to haev it not include those?

 

I also want to sum the total tasks due in the next two week. This one I am struggling with all together.

 

Any help would be appreciated!

 

Shaine Greenwood

Try a COUNTIFS function instead, which will only count what meets multiple conditions:

 

=COUNTIFS(Variance2:Variance31, >0, Completed2:Completed31, 1)

 

The one at the end is the numeric value for "checked" in a Checkbox column.

 

Take a look at our function references article in the Help Center for more information: https://help.smartsheet.com/articles/775363-using-formulas#countifs

Bryan Dillon

That worked Shane. Thanks!

 

Any thoughts on counting tasks coming due?

 

Bryan

Shaine Greenwood

You might explore a COUNT or COUNTIFS function that compares your due date column with the TODAY function.

 

You can even use TODAY(-10) in the function to calculate "ten days before the current date"

 

Check out the functions list article from my previous post to get the syntax down. A quick example of this would be:

 

=COUNTIF([Due Date]:[Due Date], > TODAY(-10))