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



  • David Joyeuse
    David Joyeuse ✭✭✭✭

    Hi @Devon Eddy

    The IFERROR formula should be like this I believe:


    I'm not sure why do you need an IFERROR here. Is there anything special with your {Pipedrive - Smartsheet Range 15}?

    Hope it helped!

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    You have the IFERROR portion correct.

    IFERROR(MONTH(@cell), 0) = MONTH(TODAY())

    Are you getting an error or are you getting an incorrect count?

  • David Joyeuse
    David Joyeuse ✭✭✭✭