Combining CountIfs statement with Date

08/31/20
Answered - Pending Review

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

Popular Tags:

Answers

  • Hi @Devon Eddy

    The IFERROR formula should be like this I believe:

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

    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 NewcomePaul 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?


Sign In or Register to comment.