Combining CountIfs statement with Date

I have a CountIfs formula that I'm having trouble getting to work when I add a date condition into it.

Basically I'm trying to get a MTD output based on several countifs as well as only counting if an adjecent cell does not contain "Appointment Allowcated". The formula works perfectly when I don't have the IFERROR statement as part of the formula but doesn't work when I add it.

Here it is: =COUNTIFS({Pipedrive - Smartsheet Range 11}, ="Appointment Scheduled", {Pipedrive - Smartsheet Range 13}, ="", {Pipedrive - Smartsheet Range 2}, NOT(CONTAINS("Appointment Allocated", @cell)), {Pipedrive - Smartsheet Range 15}, IFERROR(MONTH(@cell), 0) = MONTH(TODAY()))

Hope I can get some help! Thank you



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!