Returns true if the specified text is found in the field or expression, otherwise returns false.
Sample usage
CONTAINS_TEXT(Campaign, "Sale")
Syntax
CONTAINS_TEXT(X, text)
Parameters
X- a field or expression of any type.text- the text to find within X.textcan be a field, expression, or literal value.textis case-sensitive.
Examples
| Example formula | Input | Output |
|---|---|---|
CONTAINS_TEXT(Campaign, "Sale") |
Summer Sale | true |
CONTAINS_TEXT(Campaign, "discount") |
Summer Sale | false |