I am using Countif and HAS to count a cell if a person has selected the correct quiz answers in a multiselect field.
=COUNTIF([Q2]@row, HAS("a", "b", "c", "e"))
This is returning 0 and I am not sure why?
Are you trying to count how many times the cell has those letters in it, or are you trying to count a single cell if it contains at least one of them? At best you will only receive 1 or 0 if you are counting a single cell.
In that case you would have to incorporate an OR statement.
=COUNTIFS([Q2]@row, OR(HAS(@cell, "A"), HAS(@cell, "B"), HAS(@cell, "C")))
I'm trying to count a single cell if it has all of them checked. I'm getting a 0 even when they are all checked. These letters are options in the multiselect field.
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.
