Forum Discussion

Sarah82's avatar
Sarah82
Copper Contributor
Nov 06, 2023
Solved

Custom number format with leading letters and numbers

Hi,   I'm tying to create a SharePoint Online List as an incident register. I'm want to have an Incident ID column formatted to display the number like such: INC001, INC002 INC003 and so on. I can...
json
microsoft lists
SharePoint Online
  • ganeshsanap's avatar
    ganeshsanap
    Nov 06, 2023

    Sarah82,

     

    Adding to answer by Rob_Elliott:

     

    If you have some rows with no value in this number column, above JSON will return value like INC000 for all rows: 

    So instead of it, use this JSON: 

     

    {
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "=if(@currentField, 'INC'+padStart(toString(@currentField),3,'0'), '')"
}

     

    Output: 

    Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

ganeshsanap's avatar
ganeshsanap
MVP
Nov 06, 2023

Sarah82,

 

Adding to answer by Rob_Elliott:

 

If you have some rows with no value in this number column, above JSON will return value like INC000 for all rows: 

So instead of it, use this JSON: 

 

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "=if(@currentField, 'INC'+padStart(toString(@currentField),3,'0'), '')"
}

 

Output: 

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

Resources