CellValueRelative

Description

Returns a value from another cell, relative to the current cell.

Syntax

CELLVALUERELATIVE(<columnreference>,<rowreference>)

Arguments

Argument Type Description Optional Example Values
columnreference Text/Number A column reference – either a column name, relative offset or column index No
  • Column name: “[Source.Revenue]”
  • Column offset (negative): -2
  • Column offset (positive): “+1”
  • Column index: 3
rowreference Text/Number A row reference – either a relative offset or row index No
  • Row offset (negative): -2
  • Row offset (positive): “+1”
  • Row index: 3

Returns

Object

Examples

Expression: CellValueRelative("[Source.Revenue]",-1)
Returns: The value from the revenue column, in the row before the current row

Download

Download Example