Dear Forum,

i'm trying to create a column that calculates an ID for a row based on the category where a row is assigned. The ID which is a numerical value (increasing integer) is calculated for a new row of a specific category on the basis of the IDs already used for the other rows of this category.

So the input for the formula would be column "category" (with eg. "a", "b" or "c") and maximum value of column ID in the rows where category corresponds to the category of the new row.

Please compare the following example:

Row number	Category	ID
1	a	1
2	b	1
3	b	2
4	c	1
5	a	2
6	b	3

In the above example the next IDs per category would be a - 3, b - 4 and c - 2 and so on.

I hope that the description is quite clear and i'm looking forward to your feedback how this could be implemented.

Thank you and kind regards

Philipp

• Edited by PhilippH Thursday, July 30, 2015 8:07 AM unused html-code

Hi

you should use a workflow for this and a separate list which will keep number of each item category

When a category ( e.g. = b ) is added to your list, the workflow will check in the secondaryy list the current b's value and will fill in primary list , next will update also secondary list