Counting using Countifs if a date is present

I'm trying to create a countifs formula where if it finds a date in a column and is a particular county, it'll count that line.  

I tried this and don't get an error, but it returns a zero which is not correct.  

Thank you!!

=COUNTIFS({McAdvCareSiteReview Range 2}, (ISDATE(true)), {McAdvCareSiteReview Range 1}, "king")

 

 

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!