Formula that counts # of incidents across a date range

I have a sheet for all incidents in the company that was started in 2023 and now that we're in 2024 I need to update some formulas so it only pulls the data for the current year.

Right now the formula is =COUNTIFS({Incident Type}, [Primary Column]@row) but this doesn't take the date range into consideration.

What should this formula be?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!