Cross reference sheet formula with date limits

I'm trying to count the number of complaints for Family Medicine within the last 30 days on a metric sheet referencing the source sheet Complaint Tracker. Here is the formula I think should work:

=COUNTIFS({PR - Complaint/Grievance Data Collection Range 2}, "Complaint", {PR - Complaint/Grievance Data Collection Range 1}, "Family Medicine", {PR - Complaint/Grievance Data Collection Range 3}, >=TODAY(-30))

However, it comes back as "Incorrect Argument". What am I doing wrong/missing?

Find more posts tagged with

Formulas

Accepted answers

All comments

SSFeatures

Hi @mhahn,

I just tested out your formula and it worked correctly for me:

=COUNTIFS({Sheet A Range 1}, "Complaint", {Sheet A Range 2}, "Family Medicine", {Sheet A Range 3}, >=TODAY(-30))

Can you double check your {PR - Complaint/Grievance Data Collection Range 3} and make sure that that column is a Date column and not a Text/Number column?

mhahn

@SSFeatures It is in date format:

I just tried replicating the formula that you had above without the parenthesis and it's still returning "Incorrect Argument"

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.