Hello,
Is there a way to reset the number generated in a numbered list?
Also, is there a way that we can sort a list in alphabetical order after import?
Thank you!
Hi Sarah,
Yes, with the new release on 13th April, the Workspace Admins have a provision to reset the numbered list index if it is between 899,999,999 and 999,999,99. PFB the screenshot showing the same options
The options to reset gets enabled when the count in the list reaches 899,999,999
Thanks
Akhil
Can I ask why do you need to reset the list?
You shouldn't be referencing the code directly in a formula
In terms of sorting on a list, this has been requested a number of times
https://community.anaplan.com/t5/Idea-Exchange/Sorting-items-by-code-or-name-in-number-lists/idi-p/34843
But it is worth voting for it again!
David
To physically sort list members, you need to destroy the list (delete all members) and reload the members sorted. If this list is not used in too many line items that contain stored data, you can create a process that include the following (assume that the list that you want to sort is called LIST_A):
1. Copy all members of LIST_A to another temporary list (call it tmpLIST_A). Create a module dimensioned by tmpLIST_A (call it tmpMODULE_A). The line items in the module should include at least the name, code, parent name, and parent code of the list members. All other property values should also be included in this module.
2. Copy parent-child information (name, code, parent name, parent code) of the list along with other properties to tmpMODULE_A. In tmpMODULE_A, create a view that shows all line items sorted by the member list name (call this view vwSortedView).
3. Copy the contents of all line items (dimensioned by tmpLIST_A) to temporary modules.
4. Delete all members of LIST_A.
5. Import vwSortedView back to LIST_A
6. Import back the line items that contain data. This are the line items that are backed up in Step-3.
7. Finally, delete all members in tmpLIST_A so that it is ready for the next sort.
All of the above actions can be place in a single process so that the admin can just run the process to sort the list.
I hope it helps.
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…
