When exporting data from Anaplan to Excel, it would be great to have the option to maintain certain formatting options such as wrapped text and conditional formatting.
another thread with the same thing: https://community.anaplan.com/t5/Idea-Exchange/Option-to-export-conditional-formatting-in-export-to-xls/idc-p/122060#M9235
There is a definite need to be able to export conditional formatting from both NUX and standard reports and exporting.
At the moment we are having to replicate formatting in Excel which is time consuming. It also steers users and stakeholders to just export the raw data in Excel and continue to format and produce reports in Excel when they could be done in excel and exported where necessary
I also agree that this should be on the roadmap.
It will be kept under consideration for the roadmap of Anaplan for Microsoft 365 on Excel.
Agree with original ask. I think having the formats available in MS 365 Add in doesn't address the actual issue.
If data exported with conditional formatting from Anaplan to Excel, cells show CF but what if user wants to apply CF with another conditions in Excel? How can CF be differentiated from Original file and later applied conditions?
Description: The new conditional formatting functionality on KPI cards is a welcome enhancement to the Anaplan UX! However, hovering over a conditionally formatted KPI value or status icon displays the underlying conditional formatting configuration, including minimum, midpoint, and maximum threshold values. For dashboard…
I asked Claude to add line items and a formula to a planning model in Anaplan, and it did the job in a few minutes from plain sentences. No special add-on, no clicking through menus myself. That is exciting, and it raises the question every team should ask first: what happens to our data? The short answer is that it…
ADO can handle inbound PGP encypted files (as per https://help.anaplan.com/pgp-encryption-in-pipelines-8f662578-1a51-467b-9817-3083f170511c). However, outbound there seems to not be a solution. Please provide a way to create an encryption key using PGP for files to be provided into a SFTP connection.