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.
If you make changes to settings in the Google Sheets Add-on they apply to the entire spreadsheet, rather than individual worksheets.
To change your settings in the Google Sheets Add-on:
- Select
Settings at the bottom of the Anaplan sidebar. - Select the settings 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. 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.
- Optionally, select Change environment to change your environment.
If you change environment, you need to sign in again. - Select Apply.
The Anaplan sidebar reopens.
Your formatting and styling settings apply the next time you refresh your data or create a new connection.