5

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

Example as below:

PO-15-2001

PO-15-2002

PO-15-2003
1

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 Dec 23 '15 at 2:15
  • You did not click the link to the fancy stuff then... – Danny '365CSI' Engelman Dec 23 '15 at 7:49
  • I did and tried but the ID part it keeps coming up as 0000 – Yuges Dec 23 '15 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 Dec 23 '15 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? – Danny '365CSI' Engelman Dec 23 '15 at 10:13
0

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, privacy policy and cookie policy

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