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.