Countifs witth contains referencing another sheet

Judith Pappler

Hi all,

I cannot seem to find the issue with my formula. It gives me the error #incorrect argument set. Can someone help me? I suspect it to be the last part with the contains.

=COUNTIFS({5. EMEA - Belgium - Error Log month}, {5. EMEA - Belgium - Error Log month} = Month@row, {5. EMEA - Belgium - Error Log To be fixed by}, "Nike DM", {5. EMEA - Belgium - Error Log Type}, "workday errorlog", {5. EMEA - Belgium - Error Log fixed status}, <>"ignore", {5. EMEA - Belgium - Error Log fixed status}, <>"Not Data Management", {5. EMEA - Belgium - Error Log fixed status}, <>"Duplicate error, ignore", {5. EMEA - Belgium - Error Log fixed status}, <>"Unknown to Fix", {5. EMEA - Belgium - Error Log category}, CONTAINS("onboarding", @cell))

Thanks a lot in advance,

Judith

Kelly Moore

Hey @Judith Pappler

Try this:

=COUNTIFS({5. EMEA - Belgium - Error Log month},Month@row, {5. EMEA - Belgium - Error Log To be fixed by}, "Nike DM", {5. EMEA - Belgium - Error Log Type}, "workday errorlog", {5. EMEA - Belgium - Error Log fixed status}, <>"ignore", {5. EMEA - Belgium - Error Log fixed status}, <>"Not Data Management", {5. EMEA - Belgium - Error Log fixed status}, <>"Duplicate error, ignore", {5. EMEA - Belgium - Error Log fixed status}, <>"Unknown to Fix", {5. EMEA - Belgium - Error Log category}, CONTAINS("onboarding", @cell))

I assumed your {5. EMEA - Belgium - Error Log fixed status} was a single-select dropdown, vs a multi-select column? Is that correct?

Kelly

Kelly Moore

Hey @Judith Pappler

Try this:

=COUNTIFS({5. EMEA - Belgium - Error Log month},Month@row, {5. EMEA - Belgium - Error Log To be fixed by}, "Nike DM", {5. EMEA - Belgium - Error Log Type}, "workday errorlog", {5. EMEA - Belgium - Error Log fixed status}, <>"ignore", {5. EMEA - Belgium - Error Log fixed status}, <>"Not Data Management", {5. EMEA - Belgium - Error Log fixed status}, <>"Duplicate error, ignore", {5. EMEA - Belgium - Error Log fixed status}, <>"Unknown to Fix", {5. EMEA - Belgium - Error Log category}, CONTAINS("onboarding", @cell))

I assumed your {5. EMEA - Belgium - Error Log fixed status} was a single-select dropdown, vs a multi-select column? Is that correct?

Kelly

Judith Pappler

Hi Kelly,

It works, thank you so much! The fixed status is indeed a single dropdown.

Judith