Counting rows from another sheet that meet a specific criteria


Hi All!

I'm trying to count the amount of rows from another sheet that meet the following criteria:

All rows that are within the "Quality Control - Bioassay" department, that are not closed nor cancelled in the status column and the creation date is less than 30 days, then less than 60 days and then more than 90 days

=COUNTIFS(AND({Dev Department}@row = "Quality Control - Bioassay", NOT(CONTAINS("Closed", {Dev Status}@row)), NOT(CONTAINS("Cancelled",{Dev Status}@row))), <=30)

Not sure what I'm doing wrong - thank you!!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!