How do I create a column that auto generates a number in sequence?

Question

There are multiple users key-ing information regarding candidates on our Recruitment Database. However, I want a "Candidate number" field automatically generated every time a new line item is created. How do I do this? And how do I make this Candidate Number field, my "main" field?

Answer 1

you can create a "Candidate number" calculated SharePoint column with the formula

=CONCATENATE(Col1,[ID])

or using

=Text[ID]