Skip to main content


Workday Adaptive Planning Knowledge Center

Steps: Add Splits and Rows

Explains how to add splits to accounts in standard sheets, records to modeled sheets, and rows suppressed by filters and display options in cube sheets.

Audience: Planners who enter data in sheets.

In modeled sheets, you add new rows to add new records. You can also split rows in modeled sheets. Example: In a personnel sheet, an employee may split their time between departments. Split the employee record to allocate the resource by department.

In standard sheets, add splits to add rows. Splits break down data into further categories. Example: You have contributing factors for the Travel Expense data, including trade shows, seminars, speaking opportunities, and training expenses. Create splits to add as many lines as necessary to accommodate the travel expense. These splits roll up to the total travel expense account.

In cube sheets, add rows to expose otherwise suppressed rows. Example: If you have suppressed all rows with zeros and blanks, and you need to add data to one of those rows, adding a row reveals only the specified row, keeping the rest suppressed.  


Add Rows and Splits in Modeled Sheets

Add Rows

  1. Open modeled sheet.
    See Open Sheets.
  • Click Add Row from the toolbar.
  • Right-click anywhere on the sheet and select Add Row
  • Right-click on any row and select Copy Row. The data of the whole row copies into a new row at the bottom of the sheet.
  • Highlight multiple cells across rows, right-click and select Add x Rows or Copy x Rows (x being the number of rows selected). The same number of blank new rows, or copied rows, appear at the bottom of the sheet.
  1. Change the data for each unlocked cell in the new row and save the sheet.
    New rows appear as the last visible row in the sheet.
    After you save, you may not see new rows if your filters hide them.

Add Splits in Modeled Sheets

Available if your admin enabled this setting.

  1. Open modeled sheet.
    See Open Sheets.
  2. Right-click on any cell of the row or its existing splits and select Split Row.
    A new split appears below the parent row, or below the last split.
    Some cells are unlocked and some are locked copies of the parent row. 

Delete Rows or Splits

  1. Open modeled sheet.
    See Open Sheets.
  2. For plan versions, right-click on a row or multiple rows and select Delete Row or Delete x Rows
    If you delete a row with splits, you delete all its splits too.

For actuals versions: you can delete splits only by erasing actuals. See Erase Actuals.

Add Splits in Standard Sheets

Add Splits

  1. Open standard sheet.
    See Open Sheets.
  2. Select any cell in the same row, or any cell in the original row's splits.
  3. Right-click > Add Split
  4. Enter the split name or leave blank and click OK.
  5. After saving, notice how the original row is now a read-only total. To change the total, expand the row and change the splits.

Add Multiple Splits

  1. Open standard sheet.
    See Open Sheets.
  2. Once you have more than one split in a row, highlight a range of cells that are splits.
  3. Right-click > Add Splits
    The same number of new splits that you highlighted appears.
  4. (Optional) Right-click each new split and choose Edit/Rename Split to label the split. 

Add Splits in Standard Sheets with Dimensions

See the section, "Choose Dimensions in Standard Sheets" in Change Switches, Checkboxes, and Drop-Downs.

Rename or Delete Splits 

  1. Open standard sheet.
    See Open Sheets.
  2. Right-click any cell in the split's row and select Edit/Rename split or Delete Split.

Add Rows in Cube Sheets

Watch the video (1m 4s):

Add Rows in Cube Sheets

Use the Add Row button in cube sheets to reveal suppressed rows or to find specific rows that are already revealed.

  1. Open cube sheet.
    ​​​​​​​See Open Sheets.
  2. Activate the button:
    • From the toolbar, click Display Options and click the Suppress rows if all zeros or blank option.
    • For each dimension filter, select a dimension that you can't expand. 
    • If Add Row remains deactivated, save the sheet.
  3. From the toolbar, click the Add Row button.
  4. Choose one value from each drop-down. The dimension drop-downs are the dimensions currently in the rows. 
  5. Select OK. The sheet reveals the row and scrolls you to its location on the sheet. Your cursor moves to the first cell of the row. 
  6. Enter data and save.
  • Was this article helpful?