Contains

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

Last updated: July 22, 2020

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

contains.webp

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. This is shown in the below 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 =. This is shown in the below 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 are 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 🤓

Was this article helpful?