Mapping Sheets

Mapping is a way to connect the two sheets of your model. It enables you to add the data of a row of one sheet to the row of another sheet. 

In OnPlan, you can map two Time Based sheets using the Mapping column

Let's map the two Time based sheets Income Statement and Income Statement USA together. For that, you have to add a mapping column to the current sheet Income Statement.

To add a mapping column, select the Quick pop icon on the top right-hand side of the OnPlan platform. Select the + button on the header. A column customization menu is displayed. Enter the column name, choose the column type as Mapping, and select the sheet that you want to map from the drop-down list. 

Let's name the column as Mapping 1, and select the Income Statement USA from the drop-down list.

You can see, the new mapping column has mapped the two sheets together.

Now, in the mapping column, select a cell from any of the rows to see the drop-down list. Let's select the row Total Revenue from the Income Statement sheet. 

Next, choose a row from the drop-down list that you want to show on the current sheet. Let's select the row Other Income from the Income statement USA sheet that has no values in it.

You can see, the data of the row Total Revenue from the Income Statement sheet gets added to the row Other Income from the Income statement USA sheet.