COUNTIFS formula looking at date columns in a reference sheet


I used the Inspection Tracking template set a base. I liked it as a starting point, and added expiration dates. Looking at the metrics sheet provided, it uses this formula to look at the number of violations per month.

I also want to see the number of date violations that occurred per month. Date violations would be anything expired, so anything in the past compared to the Date (which is a Created Date column that goes off of a form attached to the source sheet). Long story short, my formula is giving me an invalid data type error and I can't seem to figure out why.

Date is a reference to the create date column and AED Expiration Date is a reference to a date column in the same sheet.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!