Why won't my COUNTIF formula not count anything from source sheet?

Carolina Rivera
edited 09/14/20 in Formulas and Functions

Hi all,

I currently have a system for three spreadsheets: 1) Masterlist for open/closed actions that feeds a 2) Open Actions sheet, and a 3) Closed Actions sheet. The formulas for the first two sheets work perfectly, however, when it comes to the third sheet (Closed Actions), my COUNTIFS formula will not count anything on it. I've tried several formulas to try and understand the cause of this issue, but nothing works. Below I've attached an example of my issue, along with the formula I'm using:

=COUNTIFS({date_closed}, IFERROR(YEAR(@cell), 0) = 2020, {date_closed}, IFERROR(MONTH(@cell), 0) = 1)

Thanks in advance!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!