1. Extensions
  2. Google Sheets Add-on
  3. Work with Anaplan model data in Google Sheets
  4. Insert columns and rows in a worksheet

You can insert new columns and rows on a worksheet that has a connection to Anaplan. This is useful if you want to perform additional calculations on the data, or add data from another source.

It's important to create a new row or column if you want to enter new data. Any new columns and rows you insert on a worksheet are preserved when you refresh the connection with Anaplan.

If you copy and paste Anaplan data to elsewhere in the worksheet, where it's no longer under the Anaplan column and row headers, the data will not be refreshed when you refresh the add-on.

Some grids use nested dimensions instead of page selectors. Be aware that if you insert new column headers between nested row headers (or new row headers between nested column headers) this will break the connection.

A Google Sheets worksheet displaying data from an Anaplan module that uses nested dimensions. A context menu has been opened for the column where the second level dimensions are. The cursor hovers over the Insert 1 left menu option.

If you need to insert new column headers within nested headers, insert them in Anaplan, then refresh the connection.

To insert a new column:

  1. Right-click the column heading either to the right or left of where you want the new column to be.
    A context menu displays.
A worksheet with a context menu displayed. Insert 1 left is highlighted.
  1. Select either Insert 1 left or Insert 1 right.
    A new column displays either to the left of the column you selected (if you selected Insert 1 left) or the right  (if you selected Insert 1 right).

To insert a new row:

  1. Right-click the row heading either above or below where you want the new row to be.
    A context menu displays.
A worksheet with a context menu displayed. Insert 1 above is highlighted.
  1. Select either Insert 1 below or Insert 1 above.
    A new row displays either below the row you selected (if you selected Insert 1 below) or above (if you selected Insert 1 above).

In some instances, when you add or remove a large number of columns or rows in a Google Sheets worksheet (independent of the Add-on), the browser tab may crash. This usually only occurs if you add or remove more than 100 rows or columns at once.

To prevent this issue, create a new connection whenever a large number of columns and rows is added or removed from the Anaplan saved view.

There is a temporary issue when removing columns or rows from nested headers. If you remove more than 30 items from a nested list in a worksheet connected to an Anaplan saved view, you may be unable to refresh the connection. When this happens, the Retrieving data dialog states that data cannot be retrieved.

You can close the dialog and discard the refresh, but the connection to Anaplan cannot be refreshed again. Create a new connection to continue working with the view in Google Sheets.