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.
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
