Hello,
I am trying to troubleshoot a formula to achieve the following outcome.
Outcome:
Count the TOTAL number of rows in which the [Request Date] column is March (3) AND the [Requestor] column is any of the following contacts:
Jesper Poulsen
Libby Martinotti
Michelle Wisbey
Annel Ayala
Anita Miazga
Amanda Ayre
Alex McCarthy
Jill Gibilisco
Background Information:
The Request Date column type is a Auto-Number/System-Generated Column [Created (Dated)].
The Requestor column type is a Contact List that DOES NOT Allow Multiple Contacts In Cell.
(Database Name: Creative Request) -- SCREENSHOT:
(Database Name: Epic Rights Creative Request -- Monthly Data) -- SCREENSHOT:
Current Formula:
=COUNTIFS({Creative Request Active Date}, IFERROR(MONTH(@cell), 0) = 3, {Creative Request ER Active}, FIND("Jesper Poulsen", @cell))