Contains

The Contains function will allow you to do new types of filters on text fields.

The best way to explain these is by an example. Suppose you have an Opportunity data source that looks like this:


Include text that contains a specific text value:

You can use CONTAINS to filter on a text field based on the content of the value.

For example:

(
Count(Opportunities,Size=Contains("qualified"))
)

This will return the number of all the opportunities that still need to be qualified. In our example the number will be 2, because of opportunity 2 and 4.


Include text that does not contain a specific text value:

You can reverse the meaning of the filters by using != instead of =. 

For example:

(
Count(Opportunities,Size!=Contains("Small"))
)

This will return the number of all opportunities not being small. In our example the number, returned by the formula, will be 3 because there is three opportunities, which does not contain the word "Small".


Case-sensitivity

These functions are all case-sensitive. This means that it's important that you match your data's UPPERCASE and lowercase letters exactly 🤓.