Export is showing formulas

Hello,

I have a grid in the New UX in which one column features Names that link to that persons' email (done through a MAILTO formula in the model). Unfortunately, when I export that grid into an .xlsx, the column populates in excel with the full MAILTO formula, instead of the name it should be showing.

Has anyone else encountered this problem, and if so, what was your solution?

Thanks!

Accepted answers

All comments

JaredDolich

@KevinMcQuillen

Great question. I have one idea that might help.

Create another line item text format and convert the name to text and export that instead.

Maybe this can be a workaround. Not sure how to export the MAILTO line item in .xlsx format as just the name.

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…
Exports with anaplan using informatica connector
I'm trying to execute an Action to export data with the use of a Mapping in Informatica. But it gives us null rows .If we export directly from Anaplan , the export file has all the rows filled. Both exports have same number of rows but in the informatica export the values appear as blank. This issue is with only some…