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 :
For example, I want the three first lines to be at 1 in Palette field, then 2 for the three next, then 3, ... automatically