I have a list with some columns, among these columns there is one named "palette". I would like to count the number of elements in the list, and put the value "1" for the ten first elements at the "palette" field. Then "2" for the 10 next elements...

I think calculated column should be a good way to do that, but I don't understand how to do this.


My list :

enter image description here

For example, I want the three first lines to be at 1 in Palette field, then 2 for the three next, then 3, ... automatically

  • Can you put an example of the input and the expected result ?
    – JayHell
    Apr 21, 2016 at 14:04
  • I have edited my question
    – Jey10
    Apr 21, 2016 at 14:26

1 Answer 1


You could use SharePoint item IDs.

Your calculated column would look like this:



1         1
2         1
3         1
4         2
5         2
6         2
7         3
8         3
9         3
10        4
...       ...

The problem with this is that it has to be a fresh list to start from ID value 1. (for example if you had 20 items in a list and you deleted them, when you will create new item it's ID will be 21, even though the list is empty)

Also, take a look at THIS.

  • yeah good idea but as you said it's not working dynamically
    – Jey10
    Apr 22, 2016 at 6:52

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.