Need to count tasks with due date past due AND complete box not checked

Tammy Parker

I am new to smartsheet and trying to create a master summary sheet referencing a huge sheet with 1600 files. I need to count "by file name" how many tasks are 1. late < 1 week

2. late >1 week < 3 months

3. late >3 months

There are columns for FILE NAME, Due Date, and a Box to check when completed.

So I need to say if this file name due date is past date < 1 week AND complete Box is NOT checked

There are several for each file name so I assume I will match on the entire column as my reference

=COUNTIFS({Off sheet file name},"ABC", then I need to match on same off sheet due date and checked box.

Hope this makes sense.

Tammy Parker

Thank you so much!! Worked perfectly!