SharePoint Lists calculated column for sequence number

Not applicable

Hi ,


I would like to use the calculated list column to create project sequence number with the following format (eg: PROJ-21-0100)

where PROJ is a prefix, 21 is the year and 0100 will be the automatic created sequence number

I don't know how to use the formula to get the 0100 to increase by 1 (eg: 0100, 0101, 0102 ) for every new project item is created.


Your help is much appreciated.


0 Replies