Formula to track issues logged for a specific year ONLY?

molly.martin924 · 04/04/23

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!

Austin Smith · 04/04/23

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.

molly.martin924 · 04/04/23

https://community.smartsheet.com/discussion/comment/370292#Comment_370292

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!

Austin Smith · 04/04/23

@molly.martin924

In the raw data reference sheet.

Formula to track issues logged for a specific year ONLY?

Answers

Help Article Resources

Categories