Count if formula to include multiple years
Hello,
I am attempting to count all the submissions for 2023 and 2024 - my current formula only allows the dashboard to reflect the current year submissions based on my helper column for the year of submission. Does anyone know how to update the formula to count all submissions from 2023 AND 2024?
Current equation: =COUNTIF({CI Tracker Range 1}, @cell = YEAR(TODAY()))
Thank you!
Tags:
Answers
-
Hi @PaigeKucz
This would do this year and last:
=COUNTIF({CI Tracker Range 1}, OR(@cell = YEAR(TODAY()), @cell = YEAR(TODAY()) - 1))
If you wanted specific years, then just sub out the "YEAR(TODAY()" portions of the formula for the relevant year .
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 439 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 67 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!