LEVEL

Returns the hierarchy levels of visible rows in a hierarchy widget.

Syntax

LEVEL(range)

• range - the range or hierarchy widget, from which the level should be returned - Value type: widget

Remarks

• For hierarchy widgets, this function returns the levels of the currently visible rows as absolute values in a column.

• This function is particularly useful for styling different hierarchy levels in different ways or for programmatic handling of hierarchy depth information.