Countifs for NEXT year
I know to get current year I can just do YEAR(TODAY())
I just need to know how to make it look at the next year "2023" and then the following year "2024" without having to change it again at the beginning of the year. etc. I always want to look at the next 3/5 years.
I did try YEAR(TODAY()+1) but that didn't do it.
Any help would be great!
Joe Goetschel | Smartsheet Director | SCS CLOUD - Smartsheet Partner
"The only real limitation of Smartsheet is the level of effort required to achieve your goal."
Best Answer
Answers
-
I think I got it to work, YEAR(TODAY())+1
Seems to work I just wont know if it broke until 2023 :)
Joe Goetschel | Smartsheet Director | SCS CLOUD - Smartsheet Partner
"The only real limitation of Smartsheet is the level of effort required to achieve your goal."
-
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!