Filtering Options: "Is any of" & "Isn't any of"

In this article

Overview

There are two conditions ( IS any of, ISN’T any of) that can be used to filter checkboxes, dropdowns, and radio buttons to match any one of or not one of the selected values. 

Running into a filter limit? This feature is most beneficial when matching multiple values of a single field. Rather than creating 1 for each, they are combined into one convenient field.

When “ is any of” condition is selected, the filter will be TRUE when any one of the values identified is included for a particular record (even if the record also contains other values which do not match the values in the filter).

Example:

For instance, the following filter: “ is any of” with two values selected: “Female” and “Male” would successfully match a record with values “Female” and “Prefer not to disclose” because it matched Female (Prefer not to disclose is irrelevant), but a record with values “Male” and “grapes” would not match.

When “ is not any of” condition is selected, the filter will be TRUE when none of the values identified is included for a particular record.

Example:

The following filter: “ is not any of” with two values selected: “Guides” and “Plugins” would match a record with all other values.

IMPORTANT: When “ is any of” condition is selected and no values are selected, no records will match.  When “is not any of” condition is selected and no values are selected, all records will match. When “is not any of” condition is selected and all values are selected, only records with no values will match (Similar to using “does not exist” condition).

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.