nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Google Sheets Add-on: Send formula driven figures back to Anaplan

Paul

The idea would be to receive information from Anaplan, have the ability to update the information using editable inputs (e.g increase sales forecast by 10%) and then send the result (of Anaplan data * 10%) back to the Anaplan module.

Comments

johan_vangerwen

Some use case to support the requirement:

Some users wants to have a more detailed planning than implemented in Anaplan and look for a solution in Excel to be combined with Anaplan. The cells for Anaplan should have a formula with sum/sumifs/lookup to the local excel modeled planning details.
Some parts of the planning process cannot be standarized. Think of contracts in real estate and in mining raw materials. Also think of tax planning where local tax regulation is something which is more not structured

gourangdesai

Totally support this idea

SalilNarvekar

This will really be useful.

If Anaplan Google Sheets Add On could work with formulas and retain them after clicking “Send and refresh”, it would significantly increase Anaplan's user friendliness and ease the transition to Anaplan.

Mitul

This feature is available in MS office & Excel but not in Google sheet, needs to be activated in Google sheets, which can support all Organisation which are using Google suite & not MS office.

SachinAgarwal

Excellent feature if brought in…It will ease the life of resources who are using Google Sheets.

Quick Links

New ideas

Quick Collapse of expanded grid rows
Quick Collapse of expanded grid rows will help improve usability of this new feature.
Expand/collapse for hierarchies on columns and line items
The new expand/collapse functionality for hierarchies on rows is a great improvement! It would be helpful to have the same functionality when a hierarchy is pivoted to the columns. This would give users more flexibility in how they structure a view while still being able to hide or show detail. It would also be useful to…
Validating ADO transformation view rows against Anaplan lists
I have encountered a gap in ADO's filtering capabilities for transformation views that I believe many integration professionals share. When working with source data, it is common to receive files that contain codes — currency codes, cost center codes, product codes — that are not relevant to the current Anaplan setup.…