Add Splits and Rows

You can use splits on standard sheets to add data.To add data on modeled sheets, you can add rows. Some modeled sheets also let you add splits to the rows.

Before You Begin

You must be connected to

Adaptive Planning

to add splits to modeled or standard sheets.

Your administrator must enable splits on the sheets.

Splits

Splits allow you to create sub-rows in sheets with values that roll up to the original row. You can add, rename and delete splits on standard sheets.

Add Splits: Right-click on the cell and click Planning
> Add Split
.
Enter a name for your new split in the field and click OK
.
A new row appears below the original row with the name you created.
The original cell turns grey (meaning it's no longer editable because it has been subdivided by the splits you created under it.)
You'll also see another new row under the splits you create called Total. This total calculates the value of the splits immediately after you enter the data in the splits.
Submit your updates and other users only see the total in the original row's cell, unless they are viewing the sheet from your level, in which case they'll see the splits and split values you created.
Rename Splits: Right-click anywhere in the split's row.
Click Planning
> Rename Split
.
Enter the new name and click OK
.
Submit your update.
Delete Splits: Right-click anywhere in the row.
Click Planning
> Delete Split
and then click OK
to remove the split. Any values entered in that split will be deleted and subtracted from the total.
Submit your change.

Add or Split Rows in Modeled Sheets

For modeled sheets you can add rows. Unlike splits, added rows in a model sheet do not sub-total or roll up to the original row because new rows are independent. Sometimes, if the sheet allows, you can split a row, which creates a sub-row under the original.

Add Rows: Right-click a cell on the worksheet.
From the right-click menu, click
Planning
Add Row
. The new row appears at the very end of the list. Some columns of the new row will contain default information (blue text).
Edit cells in the row by selecting different values from the dropdown of the cell.
Submit your updates.
Split Rows: Right-click on the row to split and click Planning
> Split Row
. A new row appears indented below the original.

Delete Rows

Whether the row is a split or an independent row, right-click anywhere on the row and click

Planning

Delete Row

To reverse a deletion, click Refresh
from the Planning
tab and select Overwrite my changes
. The row will appear, but you'll lose any other changes you've made.

You won't be given an opportunity to confirm deletion of the row.