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
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!
-
You have the IFERROR portion correct.
IFERROR(MONTH(@cell), 0) = MONTH(TODAY())
Are you getting an error or are you getting an incorrect count?
-
Help Article Resources
Categories
Check out the Formula Handbook template!