Countifs formula across sheets


I am trying to count if the UBMD Dyad (department) on the 2nd sheet (screenshot provided) is any of the ones listed on the 1st sheet and in which month(date column is on the 2nd sheet) it was completed. I was given the formula listed on the 1st sheet but the result is 0. I am not sure what is missing in the formula.

  • =COUNTIFS({UBMD Dyads from Source Sheet}, [UBMD Dyads]@row, {Date from Source Sheet}, AND(IFERROR(MONTH(@cell), 0) = 11, IFERROR(YEAR(@cell), 0) = 2021))

1st sheet

2nd sheet



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!