Construct a list using the LIST() function

The LIST() expression constructs a list from any combination of raw values, column values, and expressions. The values in the resulting list will be in the order they were given to the LIST() expression.

  • LIST("Apple", "Banana", "Cherry") produces a list of Text values: Apple, Banana, Cherry.

  • LIST([Mobile Phone], [Office Phone], [Home Phone]) produces a list of phone numbers from three column values of the current row.

  • LIST(1, (1 + 1), (6 / 2), ROUND(POWER(2, 2)), ROUND(SQRT(25))) produces a list of Number values: 1, 2, 3, 4, 5. See also: POWER(), ROUND(), SQRT()

  • LIST() produces an empty list.

See also

Expressions: The Essentials

List expressions

Construct a list from table-column references

Construct a list of values


Was this helpful?
How can we improve it?
Clear search
Close search
Google apps
Main menu
Search Help Center