ROW

ROW()[source]

Returns the row number of the current table row.

The ROW function mimics the behavior of Excel’s ROW function. It returns the 1-based index of the current row when evaluated in a table. If no table context is available (for example, when used in a named value), the formula evaluates to an error.

Parameters:

None.

Return type:

Formula

Returns:

The 1-based row index of the current table.

Supported types:

  • INTEGER

Examples

Basic usage within a table:

ROW()
# Returns 1 for the first row, 2 for the second, etc.

Used outside a table context:

ROW()
# Evaluates to an error