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.
Answers
-
Hello @RJhingoor Try this.
=COUNTIF(Created:Created, YEAR(DATEONLY(@cell)) = 2023)
-
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!