Count Past Due and Coming Due Items

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!

Find more posts tagged with

Formulas

Project Management

Comments

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))