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.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 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!