Best Of
Re: Formula to return the latest date and hour
@ilincach: if I understand correctly, you have a list with multiple elements and in a module you have per every element saved like below?
the idea is to have the format date like "YYYY-MM-DD HH24:MM" in order that you apply an order, all the rows will be correctly ordered (even if the format is TEXT).
The Line-item has the summary setup "Firstnonblank":
and in a system module take the total value that can published in the card.
As you notice the value in SYS00 is not correct: the correct value should be "2024-05-01 14:20", so what it is needed is to order the list descending on the line-item "Date Time Export" in order that the first element to be the latest Export DateTime.
So, after you populate the list and the "DateTime Export" you need to launch the Order List Action in order to put as first element the latest DateTime Export (max).
After launching the Order Action the totals will show correct result:
If you do not want to use the Order List, you could transform the TEXT Date in number like "YYYYMMDDHHMI" and put summary as MAX and transform the MAx number back in text in order to publish it.
Hope it helps,
Alex
Re: January 2024 Community Q&A Challenge — join the discussion and collect a badge!
A little bit late, but I will drop my 5 cents as well:
1.Workflows: This solution covers the most frequently asked for features that orbit around Approval flow, Comments, Feedback on the process and the Process flow itself
Really looking forward to introduce it to the users in the upcoming months.
2.Error checking on formula: Seems small but it saves so much time - especially in huge models where you can lock out other developers for longer periods of time.
3.Assets: Storing all your assets in one place which you can easily navigate? Sounds about right to me!

Re: Anaplan Connect - Script Import Files
Hi @M.Kierepka
I followed your instructions, and it worked.
Thank you very much for your help
Daniel
Re: January 2024 Community Q&A Challenge — join the discussion and collect a badge!
For me the top three items for 2023 have been…
- Create your own colour palettes - no longer have to remember those codes
- Error checking on formula - like @TimothyThomas mentions the amount of time being saved because of no longer getting the dreaded toaster time
- And finally - being able to open UX pages in model. This has saved a lot of time with development and checking.
Re: Level 3 5.51 file not downloadable
Hello @willridge ,
A quick excel tip. Go to data>get data>from other source>Web ~ plug in the web address and it will all populate to excel correctly formatted.
Re: I am hearing about custom versions these days and would love if someone provides an example of same
A list is used to represent the versions you need, often done when you need many.
Have a look at the pros and cons in this article…
Re: Anaplan bring data to future week
Hi Tom,
You could utilise your 'Week Count' line item and use POST function:
POST(Rev, Week Count)
Let me know if that works :)

Re: January 2024 Community Q&A Challenge — join the discussion and collect a badge!
Hi all,
It's hard to pick just 3, when there were so many cool features released last year. I think the importance matters depending on if someone is a builder, maintainer, end-user, and what they use Anaplan for, but these 3 are my favorite:
- Assets - store images directly in Anaplan:
- Ease of use: Until this feature, we had to decide where to store the images, then upload them, get a proper link, and only then we could use it. Now it's just upload in Anaplan and pick in the UX card.
- Quick migration: If there are models that already used some image storage, and had module with links, instead of changing it in UX image by image (which is a lot of manual work sometimes), we can copy the link of uploaded asset and just replace the old one.
- Security: Previously either images had to be publicly uploaded (making them accessible without any authorization, which could be potentially dangerous), or shared from some company cloud storage (which meant it wasn't easy to configure, then to protect from changing, or always accessible without logging to the other system separately, especially for external contractors). Now it's safe - the images are uploaded to Anaplan and can be displayed only by people that have access to the app.
- Updates to UX grid cards - for me it's one big feature of making them much, much better, like:
- Grid themes: Let's be honest, most of the cards in Anaplan are grids, so it's really important to be able to prettify them - to show which lines are summaries, which tables are more important and should catch the eye, or even to tie color to some dimension to help users understand the connections between tables.
- Freeze Panes: This is a long-waited features, that brings the functionality known from spreadsheets - thanks to it, we can display extra properties for dimensions on big tables, that are visible even if scrolling across the other dimension.
- Selectors at the top, better width settings for columns, and many more!
- Workflow:
- Really powerful feature: saves a lot of time, is reusable and built to support various scenarios (like groups and hierarchies, delegation, Anaplan processes, Time dimension with switchover etc.). It also helps that end-users get the automated and on-demand notifications. And obviously it works also in mobile app, which means some simple tasks can be done on smartphone!
- Easy to build and use: the interface is user-friendly, different options can be easily spotted, and using it feels as it should be - to the point, without unnecessary links, steps or switching.
Re: Access to Workspace
Hi kfloyd,
If you sign into Anaplan, open a model, click Users in the setting tab on the left.
Here you can see your user settings and whether you are a workspace admin or not.
Hope this helps!
Ege
