Hello,
I'm trying to find out how many requests a lawyer gets per month based on a few things:
-AFID (Auto Fill-In Date)
-Type of Request = FOIA
-Lawyer's Staff name
-Status (Red, Yellow, Green, Blue; However, these are not in as words, they're in as "Visual Symbols")
This is what I have right now (changing name for anonymity purposes): =COUNTIFS({AFID}, AND(IFERROR(MONTH(@cell), 0) = 12, IFERROR(YEAR(@cell), 0) = 2019, {Type of Request}, FIND("FOIA", @cell), AND(IF({Law Staff}, FIND("Karen Cappa", @cell), IF({Status} = GREEN) > 0)