Hi,
The number of IDs on the numbered list is 999,999,999 (based on information in topic related with numbered lists)- what about reaching this limit. Is there any list renumbering possibility?
Hi
Just to clarify, this restriction applies to all lists, not just numbered lists.
We often see this happening with transactional data loads where the whole list is cleared out each time before being re-loaded and where "combination of properties" are used to create the numbered list. With large datasets, if this is done on a daily basis, the index will reach the limit in a very short time.
It is best practice to try and avoid mass "delete and re-load" for this reason. Techniques include using incremental imports and having a unique key in the data source wherever possible. It is important to try and work with the owners of the source data to aim for correct format in the source data and always use a unique key if possible. Aside from minimising the issue above, an import using a key is much quicker
Very often this mass delete / reload is not actually required. If a unique key is used, if the data changes in the source from the values loaded previously, the new update will update the "record" with the new value
I hope that helps
David
My understanding is that once the limit is reached the only thing to do is to create a new numbered list and repoint everything to the new list.
I'd love to hear from others if that is not the case, though.
Hi - this is a fairly common scenario for usages of numbered lists and a number of users have experienced the same frustration that you have. We are looking at an automatic solution for this problem to be released in the near future. In the meantime, if you are stuck then please contact support and they may be able to reset the sequence for you.
You can mark that list as a "production data" and create model from revision tag (Revision Tags tab). It'll be reset in a new model.
In some cases it is easier than creating new list and changing all links/actions/line item formats.
Regards,
Hayk
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…
