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.
- Right-click on the cell and click Adaptive > 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.
- Right-click anywhere in the split's row.
- Click Adaptive > Rename Split.
- Enter the new name and click OK.
- Submit your update.
- Right-click anywhere in the row.
- Click Adaptive > 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.
- Right-click anywhere on the Adaptive grid of your sheet and click Adaptive > 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.
Right-click on the row to split and click Adaptive > Split Row. A new row appears indented below the original.
Whether the row is a split or an independent row, right-click anywhere on the row and click Adaptive > Delete Row.
To reverse a deletion, click Refresh from the Planning tab and select Overwrite my changes. The row will appear, but you'll loose any other changes you've made.
You won't be given an opportunity to confirm deletion of the row.