Add comment field to a Time dimensioned module

We have a process that users import data via Excel to Anaplan. The file format is shown as attached. The business would like to add a comment field at the end of the column for each project (see screenshot. the comment field is just a mock-up on Excel and does not exist in Anaplan yet).

To add a comment field in this time dimensioned module and nicely present it on the export, any recommendation? Thank you!

Tags

Importing and Exporting Data

Data Integration

Accepted answers

You can use the same file for multiple imports so I would store the comments in a SYS Project module that does not have Time associated with it.

Also, in looking at the Project code, are those numbers part of a date or the real project code? I ask because having the date as part of a code could lead to longer (bigger) lists than actually needed.

Rob

All comments

KirillKuznetsov

Please attach the file

Capture2_117141.JPG

Strange I did upload as picture. I've just posted it in the reply. Thanks.

You can use the same file for multiple imports so I would store the comments in a SYS Project module that does not have Time associated with it.

Also, in looking at the Project code, are those numbers part of a date or the real project code? I ask because having the date as part of a code could lead to longer (bigger) lists than actually needed.

Rob

These project codes are truly codes.

I guess you meant creating an additional import action to include in this process and it will be seamingless to the users?

They actually export this file first, update numbers and import it back. Then they will have to add the comments by themselves I assume?

Crazy question, but why are they exporting the data, updating it, and then importing it back in? Why not just update the data within Anaplan?

Do you mean to update the data directly on the web?

Because there are too many projects to update....People just like using Excel...

So even if people update data within Anaplan, would there be a good way to present the Comment field on the grid?

Not in the way you have it in the above attachment. It would be on a different card.

ChrisAHeathcote

If your users insist on using Excel, have you considered using the add-in which will allow you to write back into Anaplan after each edit.

Or you could create a worksheet and train the users to pivot and filter the data to allow them to edit directly in Anaplan.

Exporting and importing back seems completely redundant.

Quick Links

Can you help?

Unanswered questions

Add list members to a selective access list
Hi, I am working on a solution where the User should only have access to write/edit the list members that they add from an Action on the frontend. This action adds another list member to a selective access list. The problem is, in order to run the action, you need access to the entire list, so you would see all list…
Dimensionality Issue
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
Formula to return Connection details...
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?