Construct a list of values

A list can be constructed from raw values by enclosing the raw values in curly braces (`{`, `}`). The list must have at least one value. Multiple raw values should be separated by a comma (`,`). All raw values within the list must be of the same data type.

• `{ "Apple", "Banana", "Cherry" }` constructs a list of `Text` values: `Apple`, `Banana`, `Cherry`.
• `{ 1, 2, 3 }` constructs a list of `Number` values: `1`, `2`, `3`.

Within curly braces, expressions are loosely recognized but may be evaluated in unexpected ways or not evaluated at all. Using expressions within curly braces is strongly discouraged! To use a raw value that might be interpreted as an expression, enclose the raw value in double quotes (`"`).

• `{ [Mobile Phone], [Office Phone], [Home Phone] }` produces a list of `Text` values: `[Mobile Phone]` , `[Office Phone]` , `[Home Phone]`. Because the raw values appear to be expressions, the expressions will be checked for validity and may produce errors (e.g., if a column doesn't exist), but these apparent expressions will not be evaluated!
• `{ 1, (1 + 1), (6 / 2), ROUND(POWER(2, 2)), ROUND(SQRT(25)) }`  produces a list of `Number` values: `1`, `1`, `1`, `6`, `2`, `4`, `5`. Note that these expressions are recognized but do not produce the expected results! See also: `POWER()`, `ROUND()`, `SQRT()`
• `{ "(1 + 1)", "(6 / 2)" }` produces a list of Text values: `(1 + 1)`, `(6 / 2)`. Note the apparent expressions are not recognized as expressions within the quotes.

List expressions

Construct a list using the LIST() function

Construct a list from table-column references

`LIST()`