CONTAINS_TEXT

Returns true if the specified text is found in the field or expression, otherwise returns false.

Sample usage

CONTAINS_TEXT(Campaign, "Sale")

CONTAINS_TEXT(X, text)

X - a field or expression of any type.
text - the text to find within X. text can be a field, expression, or literal value. text is case-sensitive.

Example formula	Input	Output
`CONTAINS_TEXT(Campaign, "Sale")`	Summer Sale	true
`CONTAINS_TEXT(Campaign, "discount")`	Summer Sale	false

Was this helpful?

How can we improve it?