# Get Hierarchical Cell Index

A list of the formulas for getting hierarchical cell indexes in SpreadJS ReportSheet

## Content

ReportSheet uses [context ](/spreadjs/docs/features/reportsheet/templatesheet/context)to analyze cell formulas. If a cell contains context, the preview mode displays the data in the spilled cell in a hierarchical tree structure. You can get cell values, indexes, or ranks in a tree by using certain ReportSheet formulas. These formulas are called **Hierarchical Cell Indexes**.
Hierarchical cell index has three important functions:

* [Get Value](/spreadjs/docs/features/reportsheet/templatesheet/formula-functions/hierarchical-cell-index/get-value)
* [Get Index ](/spreadjs/docs/features/reportsheet/templatesheet/formula-functions/hierarchical-cell-index/get-index)
* [Get Rank ](/spreadjs/docs/features/reportsheet/templatesheet/formula-functions/hierarchical-cell-index/get-rank)

Additionally, ReportSheet offers the following shortcut functions to easily obtain the cell values:

* [R.MOM](/spreadjs/docs/features/reportsheet/templatesheet/formula-functions/hierarchical-cell-index/rmom)
* [R.YOY](/spreadjs/docs/features/reportsheet/templatesheet/formula-functions/hierarchical-cell-index/ryoy)
* [R.PROPORTION](/spreadjs/docs/features/reportsheet/templatesheet/formula-functions/hierarchical-cell-index/rproportion)
* [R.CUMULATIVE](/spreadjs/docs/features/reportsheet/templatesheet/formula-functions/hierarchical-cell-index/rcumulative)