=HASVALUE
The HASVALUE Function returns true if any value exists within the parentheses.
Syntax
Section titled “Syntax”=HASVALUE(DoesAnyValueExistWithinTheParentheses)Parameters
Section titled “Parameters”- DoesAnyValueExistWithinTheParentheses – The field token or value you want to check for content.
How It Works
Section titled “How It Works”-
Evaluates the value inside the parentheses.
-
Returns 1 (true) if there is any value present.
-
Returns 0 (false) if the field or value is empty, null, or blank.
Usage Notes
Section titled “Usage Notes”-
Use for conditional actions based on whether a field has been filled.
-
Formula functions are case sensitive and must be written in ALL CAPS.
Example
Section titled “Example”Returns 1 (true) if the field contains any text.
Returns 0 (false) if the field is empty.
Keywords
Section titled “Keywords”HASVALUE, check value, field validation, value exists, conditional logic, workflow formulas, process field check, Boolean function, formula function