Forum Discussion

andrewmice's avatar
andrewmice
Copper Contributor
Apr 09, 2020
Solved

Creating a unique id field

I really need an new field that displays an auto generated ID.   I don’t want it to be the built in ID number, I need it to be a reference number that ‘concatenates’ (I think that’s the right word?...
developer
Lists
SharePoint Online
  • Swaminathan Sriram's avatar
    Swaminathan Sriram
    Apr 09, 2020

    Hi,

    You can create a Calculated Column with the below formula to concatenate and display as per your need.

    Formula is =CONCATENATE(LEFT([ClientName_Field],3),TEXT([Date_Field],"ddmmyy"))

    Please change the fields name as per your List Columns.

     

    Also, please refer to this link for common formulas for Calculated Column which would be helpful - https://support.office.com/en-us/article/examples-of-common-formulas-in-sharepoint-lists-d81f5f21-2b4e-45ce-b170-bf7ebf6988b3

     

    andrewmice 

    I hope this is helpful, please like it or mark it as a solution if it answers your query.

    Thanks.

Swaminathan Sriram's avatar
Swaminathan Sriram
Iron Contributor
Apr 09, 2020

Hi,

You can create a Calculated Column with the below formula to concatenate and display as per your need.

Formula is =CONCATENATE(LEFT([ClientName_Field],3),TEXT([Date_Field],"ddmmyy"))

Please change the fields name as per your List Columns.

 

Also, please refer to this link for common formulas for Calculated Column which would be helpful - https://support.office.com/en-us/article/examples-of-common-formulas-in-sharepoint-lists-d81f5f21-2b4e-45ce-b170-bf7ebf6988b3

 

andrewmice 

I hope this is helpful, please like it or mark it as a solution if it answers your query.

Thanks.

Resources