COALESCE
Returns the first non-empty value, or NONE if all values are empty. A value is non-empty if ISNOTEMPTY(<expr>) returns true. If there are no values passed in, it returns NONE.
Syntax
=COALESCE()
=COALESCE(expr1)
=COALESCE(expr1, expr2, ..., exprN)
Arguments
| Argument | Type | Description |
|---|---|---|
| exprN | String, Array or Object | Any value. The first non-empty value will be returned |
Examples
=COALESCE() → NONE
With no arguments, COALESCE returns NONE.
=COALESCE("A") → "A"
The only argument is non-empty, so it gets returned.
=COALESCE("", "B", NONE) → "B"
Returns the first non-empty string.
=COALESCE(OBJECT(), NONE, []) → NONE
Every argument is empty, so COALESCE returns NONE.
=COALESCE(" ", OBJECT("A", 1)) → OBJECT("A", 1)
An object with keys is not empty, but a string of whitespace is.
Updated 9 months ago