=EQUALS
The EQUALS function checks whether a value (typically a process field) matches any of the specified comparison values. Commonly used for validation, conditional logic, and workflow decisions. The EQUALS function is formatted as follows:
Syntax
Section titled “Syntax”=EQUALS(DoesThisValue; EqualThisValue; AndThisValue; AndAllOtherValuesWithinTheParens)Parameters
Section titled “Parameters”-
DoesThisValue
- The value or process field you want to evaluate.
-
EqualThisValue, AndThisValue, AndAllOtherValuesWithinTheParens
-
One or more values to compare against.
-
Each value must be separated by a semicolon (;).
-
How It Works
Section titled “How It Works”-
Compares DoesThisValue against all provided comparison values.
-
If the value matches any of the listed values, the function returns 1 (true).
-
If the value matches none of the listed values, the function returns 0 (false).
Usage Notes
Section titled “Usage Notes”-
You may include as many comparison values as needed.
-
All comparisons are evaluated within the same set of parentheses.
-
Semicolons (;) are required to separate values.
-
Formula functions are case sensitive and must be written in ALL CAPS.
Example
Section titled “Example”=EQUALS([[Field: number (Number)]]; 1)- Returns 1 (true) if the field value is 1.
Keywords
Section titled “Keywords”EQUALS, equals function, value comparison, field validation, conditional logic, workflow formulas, process field comparison, boolean function, formula function