How do I change the default "Title" column in SharePoint 2013 into a column which have sequence number generate automatically?

Example as below:




2 Answers 2


No need for separate tables keeping track of a unique number, the ID value is unique.

But you can not use it in a calculated column directly so you need one Workflow to write the item ID to another column myID

You can then use a Calculated column

="PO-" & TEXT( [Created] , "yy" ) & "2" & TEXT( [MyID] , "000" )

If you really want this in your Title column you have to add this string building to your first Workflow and set the Title field

If you need more fancy stuff:

Create unique number with ListItem [ID] and [Today] age in Calculated Column Formula

  • Hi Danny.. How to do it without workflow?
    – Yuges
    Commented Dec 23, 2015 at 2:15
  • You did not click the link to the fancy stuff then... Commented Dec 23, 2015 at 7:49
  • I did and tried but the ID part it keeps coming up as 0000
    – Yuges
    Commented Dec 23, 2015 at 9:59
  • the command is as below ="PO-"&TEXT(Created,"YY")&"-"&TEXT(ID,"0000") the result is PO-15-0000 each time I add new item.
    – Yuges
    Commented Dec 23, 2015 at 10:02
  • You are using [ID] , that is not what the posts tell you to do. What name did you give your second ID column? Commented Dec 23, 2015 at 10:13

You will need a workflow.

Step 1 - create a table with 1 item to keep track of the unique number (200x) (can also record any other information needed as well here)

Step 2 - create the workflow that gets that item's value and sets the Title field to PO-15-[Number]. Update the current number in the other list by incrementing it by 1 (or any other logic you have).

Step 3 - Profit.

Conversely you can use the ID number of the item it's self although be aware you can not edit the ID.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.