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