Formula to track issues logged for a specific year ONLY?
Hi!
We currently have a log that captures issues for 2022 and 2023. I'm attempting to track our "Ops Issue" and Labeling Issue" categories for 2023 ONLY and am having a hard time with adding additional date criteria to the COUNTIF formula. The screenshot below reflects my latest attempt at capturing the 2023 data. Please help!
Thanks!
Answers
-
I'd make a helper column named YEAR that has the column formula =Year(date reference), then make your countif formula a countifs. =COUNTIFS([Labeling Issues Log Range 5], "Ops Issue", YEAR:YEAR, "2023")
AND and OR are somewhat less friendly in Smartsheet than they are in Excel, making them a bit more cumbersome to use than pluralized formula formats.
-
Apologies for my naivety, but where are you suggesting I add the YEAR helper column? Would I add it to the sheet I am attempting to reference? Or in the summary sheet where I am collecting the referenced data?
Thanks for your help!
-
In the raw data reference sheet.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!