How do I make the below data cells within a module editable?
@lcapon
Remove the formula for the line item, but I am not sure you want to do that as the formula was put there for a reason, I would think.
If there is not a formula, then you are viewing data at an aggregated level (detail time granularity is at days or weeks while you are viewing/showing months or list is at the SKU level and you are looking at the Brand level) and there is nothing to be done, unless you create another module at the summary level you are desiring.
Rob
Hi @lcapon!
There are several reasons why data can be closed from editing:
1. They are calculated using the formula (as Rob wrote above).2. This is aggregated data.3. You do not have write access to the cell (governed by selective access, version settings, or dynamic cell access).4. These are the actual months on the forecast version.
To check the last point: see if there is a version in the module and if the switchover on. It is possible that you do not need it.
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
A while back, I shared a pattern for extracting and reporting on Anaplan audit data using a Python project hosted on GitHub. I wrote that during my time on the Operational Excellence Group (OEG) at Anaplan. The Python solution still works, and plenty of teams are running it today. The problem it solves hasn't changed:…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
