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
Check out the Formula Handbook template!
