In a formula how can I reference the outline level of a row?
 

I would like to create a column that automatically calculates an outline
number of a row in a spreadsheet based on its level of indenture when rows
are grouped and ungrouped in Outline mode.

In a formula how can I reference the outline level of a row?
 

Select A1. Create a named variable, like "level" -- Insert/Name/Define, type
Level. In the Refers to, use =GET.CELL(28,A1)
In the worksheet, enter =level and it will return the row level. For column,
use GET.CELL(29,A1)

"Dana DeLuca" wrote:

I would like to create a column that automatically calculates an outline
number of a row in a spreadsheet based on its level of indenture when rows
are grouped and ungrouped in Outline mode.