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.

Find more posts tagged with

Formulas

Sheet Summary

Accepted answers

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.