Countifs Formula Including Keyword Search and Date Range

PPMRL

Hello,

I am attempting to build a live chart that tracks the number of open items from a smartsheet and also organizes them into date ranges based on todays date. I am currently using the countif function to organize the data into 30+ days outstanding, 60+ days outstanding, etc. but I would like to exclude any items that have been listed as complete. The current formula I am using is:

=COUNTIF({PurePM-Ron Weekly Tracker Range 3}, >=TODAY(-60)) - [30+ Days Outstanding]@row

Looking to organize the data based on the origin date and status columns.

AravindGP

Hi @PPMRL

You will need to add the Status reference in your other sheet and set the criteria as <>"Complete", using the less than and greater than symbols in this manner takes is as not equal to. Your COUNTIF will change to COUNTIFS as there are multiple conditions.