Please help. I've attached screenshots and don't know why I keep getting the time error message. Thanks.
Yes- I used the YYYYMM format but kept running into the same issue.
Hi Adinah,
Can you share the error message you are getting?
Thank you for replying.
The error message was what I had before changing the P2 and G3 from "product code" to "fixed". Can you explain why changing those affected the error message in my screenshot?
If you look at the mapping screen for the date fields in your import you should be able to change the format that Anaplan is expecting to the one in the file. Note if it is a line item and not a dimension then you may need to check the check box next to the date line item(s) to configure dates.
Look at the base data and select the most appropriate format. So if the date is showing as MM/DD/YYY then pick MMDDYYYY etc.
Your column Headers are in YYYYMM format - there are no days.
Can you set the import to be a period instead of a date?
It was set to period. I got it but thank you.
Hi everyone 👋 If you build or maintain Anaplan models, you've probably hit the same walls I kept hitting. Some basic questions about a model's structure have no single screen to answer them. You end up clicking through modules and pages one by one, or writing API scripts just to get a list. These were the gaps that…
Hi Everyone, We have a requirement in Anaplan Consolidation & Reporting (Fluence) where the Entity Structure needs to change effective January 2026. The key requirement is that the existing entity structure should continue to be applicable for all reporting and consolidation periods through December 2025, while the new…
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…
