Tallying Totals in Summary

RJhingoor

=COUNTIF(Created:Created, YEAR(@cell) = 2023)

Generates invalid data type

Created is a autogenerated date time column when the row is created.

example of format -

I can get a single cell from the column to return 2023 using the Year() function but when using it in the formula above with @cell it errors. I feel like I am overlooking something simple.

I want to use this column to count the number of entries we have for the year.

Thanks for any guidance.

Eric Law

Hello @RJhingoor Try this.

=COUNTIF(Created:Created, YEAR(DATEONLY(@cell)) = 2023)

RJhingoor

It still comes back invalid. In the meantime I have created a new column that pulls the last two digits of the year out of the date time column. Now I can count on 23 or 22 or 24 for next year.