1

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?

3
  • 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 Commented Jul 29, 2016 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
    Commented Jul 29, 2016 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 Commented Jul 29, 2016 at 5:21

2 Answers 2

0

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.

1
  • Because I need to be able to set the number field with any number like 100 or 1000.
    – Anthony
    Commented Jul 29, 2016 at 5:20
0

You can use formula like below

[ID]+StartingNumber

E.g.

[ID]+1000

It will automatically increase every time whenever new item created.

3

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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