SharePoint Lists calculated column for sequence number

%3CLINGO-SUB%20id%3D%22lingo-sub-2116302%22%20slang%3D%22en-US%22%3ESharePoint%20Lists%20calculated%20column%20for%20sequence%20number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2116302%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20use%20the%20calculated%20list%20column%20to%20create%20project%20sequence%20number%20with%20the%20following%20format%20(eg%3A%20PROJ-21-0100)%3C%2FP%3E%3CP%3Ewhere%20PROJ%20is%20a%20prefix%2C%2021%20is%20the%20year%20and%200100%20will%20be%20the%20automatic%20created%20sequence%20number%3C%2FP%3E%3CP%3EI%20don't%20know%20how%20to%20use%20the%20formula%20to%20get%20the%200100%20to%20increase%20by%201%20(eg%3A%200100%2C%200101%2C%200102%20)%20for%20every%20new%20project%20item%20is%20created.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYour%20help%20is%20much%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2116302%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Deleted
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