What formula I can use in a column so the value in the field always increases by 1 every time a new item is created?

| improve this question | | | | |
  • Please elaborate your question. Where and how you want to use this calculated column formula? As detail description of the question will help others to understand your question – Dikesh Gandhi Jul 29 '16 at 4:57
  • Alright, I'm trying to import and keep adding items with a number code that will start at 1000 for example. What I want is when an user creates a new item in the list the code number field changes to 1002, if another user creates an item it changes to 1003 and so on. – Anthony Jul 29 '16 at 5:19
  • In calculated column, you can only get column related info for calculation, You can not get previous row data for calculation. Instead You can use event receiver i.e. "item adding" for that. It would be better for your requirement – Dikesh Gandhi Jul 29 '16 at 5:21

Why do you want a calculated column for it? You may use the default ID column, which will automatically get incremented by 1 whenever a new item is created.

| improve this answer | | | | |
  • Because I need to be able to set the number field with any number like 100 or 1000. – Anthony Jul 29 '16 at 5:20

You can use formula like below




It will automatically increase every time whenever new item created.

| improve this answer | | | | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.