Tallying Totals in Summary

=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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!