Cross reference sheet formula with date limits

mhahn

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?

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"