Invalid Data Type - Date Column Sourced

Maddy Menna

Hi All,

I created a metric sheet for my Dashboard with a section to count how many ground breaks I will have in 2024. The formula is sourcing a date column in my Summary Sheet.

I entered the following formula into my cell:

=COUNTIF({Summary Sheet Range 2}, YEAR(@cell) = 2024)

Any ideas on why it's throwing an invalid data type error? Both columns are Text/Number.

Thanks for your help!