1. Extensions
  2. Google Sheets Add-on
  3. Settings
  4. Change the default settings

In the Google Sheets Add-on, choose whether Anaplan line item formatting and grid styling is applied to your worksheet when you create or refresh a connection.

You must be signed in to the Google Sheets Add-on to change the default settings.

Anaplan line item formatting is always enabled for read-write connections.  If you deselect Apply Anaplan line item formatting, this only affects read-only connections.

To change the default settings for the Google Sheets Add-on:

  1. In the Anaplan sidebar, select Settings.
    The Settings menu opens.
  2. Select the settings you want to apply to your Anaplan data when you create a new connection or refresh a connection:
    • Select the Apply Anaplan line item formatting checkbox to ensure cell formatting from Anaplan is applied.
      Note: Conditional formatting is not supported.
    • Select the Apply Anaplan grid styling checkbox to ensure that Anaplan styles are applied to your data, such as cell borders, cell colors, font colors, etc.
  3. Click OK.
    You're returned to the Anaplan sidebar.
    Your formatting and styling settings are applied the next time you refresh your data or create a new connection.