COL
Column value using COL[A] or COL[1] syntax
COL is a special keyword designed for use within lambda functions like MAP, FILTER, and GROUPBY. It allows you to reference specific columns by letter (COL[A]) or number (COL[1]) when processing rows of data. This enables powerful row-by-row transformations and filtering operations across multiple columns.
Syntax
COL()
Related Functions
Other Special Functions & Keywords functions:
- CELL - Current cell value in criteria formulas
- ONCE - Returns the value of the inner formula and only executes once, turning the cell into a value
- ONCHANGE - Returns initial_value until the range changes, then returns value_after_change and converts the cell to a static value
- RECORDID - Salesforce record ID for this workbook
- TAGS - Converts a table with headers and rows into a JSON object array. There should be a "label" column and each row is rendered as a hoverable tag with that label.
- USERID - Current logged-in user's ID
← Back to Formula Reference