=FIRSTVALUE
The =FIRSTVALUE() function accepts a semicolon list and returns the first list item that contains a value.
Syntax
Section titled “Syntax”=FIRSTVALUE(Item1; Item2; Item3; ...)Parameters
Section titled “Parameters”-
Item1, Item2, Item3, …
-
A list of values separated by semicolons.
-
Items may be empty or contain values.
-
How It Works
Section titled “How It Works”-
Evaluates each item from left to right.
-
Returns the first non-empty value in the list.
-
If all items are empty, the function returns an empty value.
Usage Notes
Section titled “Usage Notes”-
Semicolons (;) are required as list separators.
-
Useful for fallback logic and default value selection.
-
Formula functions are case sensitive and must be written in ALL CAPS.
Example
Section titled “Example”=FIRSTVALUE( ; ; Item3; Item4; ; Item6)Returns: Item3
Keywords
Section titled “Keywords”FIRSTVALUE, first non-empty value, fallback value, default selection, semicolon list, list evaluation, workflow formulas, conditional logic, formula function