=CONTAINS
The CONTAINS function returns true if a specified search value is found within another text value. Otherwise, it returns false.
Syntax
Section titled “Syntax”=CONTAINS(DoesThisValueExist; AnywhereInsideThisValue)Parameters
Section titled “Parameters”-
DoesThisValueExist
- The value or text you want to search for.
-
AnywhereInsideThisValue
- The text or field token where the function will look for the search value.
How It Works
Section titled “How It Works”-
Checks whether the search value exists anywhere within the target text.
-
Returns 1 (true) if the search value is found.
-
Returns 0 (false) if the search value is not found.
Usage Notes
Section titled “Usage Notes”-
Use a semicolon (;) to separate the search value and the target text.
-
Field tokens can be used to reference process fields.
-
The function is case sensitive, so text must match exactly.
Example
Section titled “Example”=CONTAINS(Easy; [[Field: Address (Text)]])- Returns 1 (true) if the word “Easy” exists anywhere in the Address field.
Keywords
Section titled “Keywords”CONTAINS, text search, find text, string contains, field validation, conditional logic, formula function, workflow formulas, process field check