GetRow( )

Classic Experience Functions & Formulas
,
1

GETROW( )

Description

GETROW( ) returns a rowlink to a table or output of a filter expression relative to the supplied context row. Any positive or negative integer can be used.

Syntax

=GETROW(table, offset, rowlink)

Required

  • Table/filter: A table or filter that returns a list of rows.

  • Offset: Any integer. Returns #N/A if offset is out of bound.

  • Rowlink: Reference to a row within the specified table or filter.

Examples

GETROW

=GETROW(Tasks, 1, THISROW())

Returns the next task in the “Tasks” table

=GETROW(Tasks, -1, THISROW())

Returns the previous task in the “Tasks”

=GETROW(Filter(...), 1, FINDROW(...))

Passes the reference to the filter to navigate within a filtered set

Was this article helpful?
  • Yes
  • No

0 voters

2