Countifs, Does not contain for Multi-select fields

Hi,

I'm trying to add several does not contains for a countif and I can't seem to find where I'm going wrong. I keep getting #invalid operation.

My goal is to filter the field for the following:

Youth or Adult = Adult
New or Continuum = New Enrollment
Date Processed = Is Blank
Parent coordinator (multi select drop down) = DOES NOT CONTAIN - None, Waiting for Assigment, Exited the program & Student(s) Denied.

I'm successfully able to filter for the first three filters and one of the fourth filter, but when I add the remaining DNC filters, I get an error.

=COUNTIFS({Enfrmcheckin - youth or adult}, HAS(@cell, "Adult"), {Enfrmcheckin - new or contin student}, HAS(@cell, "New Enrollment"), {Enfrmcheckin - parent coordinator}, NOT(CONTAINS("NONE", @cell)) + NOT(CONTAINS("Waiting for Assignment", @cell)) + NOT(CONTAINS("Exited the program", @cell)) + NOT(CONTAINS("Student(s) Denied")) + {Enfrmcheckin - Insch date proc in ETO}, <>"")

Thanks!

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Is it possible more than one option will need to be selected in a single cell? What are the remaining options that would be counted?

Rebecca Bennett

Yes. There are 4 other remaining options in the multi-choice selection. There is a small chance that more than one option could be chosen of those remaining 4. The other fields are single-choice drop-down fields.

heyjay

=COUNTIFS(

{Enfrmcheckin - youth or adult}, 	HAS(@cell, "Adult"), 

{Enfrmcheckin - new or contin student}, HAS(@cell, "New Enrollment"), 

{Enfrmcheckin - parent coordinator}, 
	or(@cell (NOT(CONTAINS("NONE", @cell))),
	or(@cell (NOT(CONTAINS("Waiting for Assignment", @cell))),
	or(@cell (NOT(CONTAINS("Exited the program", @cell))),
	or(@cell (NOT(CONTAINS("Student(s) Denied"))),

{Enfrmcheckin - Insch date proc in ETO}, <> "")

Paul Newcome

Give this a try:

=COUNTIFS({Enfrmcheckin - youth or adult}, HAS(@cell, "Adult"), {Enfrmcheckin - new or contin student}, HAS(@cell, "New Enrollment"), {Enfrmcheckin - parent coordinator}, AND(NOT(CONTAINS("NONE", @cell)), NOT(CONTAINS("Waiting for Assignment", @cell)), NOT(CONTAINS("Exited the program", @cell)), NOT(CONTAINS("Student(s) Denied", @cell))), {Enfrmcheckin - Insch date proc in ETO}, <>"")

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.