Hello,
I am trying to troubleshoot a formula to achieve the following outcome.
Outcome:
Count the TOTAL number of rows in which [Assigned To (In-House Designer)] is "Danielle Morrison" AND the [Request On Hold] checkbox in UNCHECKED.
Background Information:
The Assigned To (In-House Designer) column type is a Contact List that Allows Multiple Contacts In Cell.
4 of the rows is ONLY ASSIGNED to Danielle Morrison
1 of the rows is BOTH ASSIGNED to Danielle Morrison and Damu Grooves.
Total rows ASSIGNED TO Danielle Morrison = 5
(Database Name: Creative Request) -- SCREENSHOT:
(Database Name: Creative Request - Dashboard Information) -- SCREENSHOT:
Current Formula:
=COUNTIFS({Creative Request In-House Designer}, "Danielle Morrison", {Creative Request On Hold}, false)