The Add-On for Google Sheets will not open and allow us to connect from large workbooks. It only seems to work with smaller/single sheets. Has anyone else experienced this? Is this a limitation of the add-on?
Hi, there are standard Google Sheets limits for worksheets applicable. You're limited to:
There's no limit to the number of rows you can have in a worksheet. You cannot create a connection to a module that contains a dimension with more than 1 million items.
Note:Β A connection between Anaplan and a new worksheet uses at least 26,000 cells from the 1 million in the worksheet. This is to protect any custom data you enter into cells outside the data you retrieve from Anaplan.
For more details refer the following Link: https://help.anaplan.com/anaplan-add-on-for-google-sheets-12e56d54-c37e-4791-9771-1a6bbee8e4d5
Just curious :)β¦
Hello fellow Anaplaners, I have a question about the UX for Anaplan for hierarchical list. If I have a list with multiple layers, say P1, P2, P3, and P4, and the workpage had 2 axis, list and line items, in its vertical axis and time in its horizontal axis (see figure below) The list is shown without indentations, and mayβ¦
I have seen two methods used to build financial statements and I am wondering what others have experienced in scalability/maintenance between the two or if there is a better approach. Assume that we have a flat data source for our general ledger within Anaplan. Our line item we are focused on within the source data is theβ¦