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

Find more posts tagged with

Formulas

Accepted answers

All comments

David Joyeuse

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.