Hello everyone,

Need some help with this formula, thinking i have too much going on here?

=COUNTIFS({Environmental Incident Tracking Range 1}, AND({Environmental Incident Tracking Range 3} = 1, YEAR({Environmental Incident Tracking Range 4} = 2020, {Environmental Incident Tracking Range 1}, "Leak")))

Environmental Incident Tracking is the sheet I am trying to pull from.

Basically, for every quarter, I am looking for the total number of leaks reported, for the year 2020




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!