0

Looking for a way to concatenate multiple field values [Created By] and [Category] into the "Title" field as [Created By - Category] either using column formatting or calculation values. I'm not very familiar with these in the online environment at all and have not found anything remotely close in my searches. Thank in advance!

1
  • You can show the concatenated values in title field using JSON column formatting. But note that this will not store/set the value in Title field. It will just show the concatenated value in list view. Nov 11, 2021 at 6:43

1 Answer 1

1

Please follow the steps:

1.Here is my SharePoint list

enter image description here

2.Title >> Column settings >> Format this column

enter image description here

3.On the Format panel, click "Advanced mode" link

enter image description here

4.Please use the below JSON formatting:

{
    "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
    "elmType": "div",
    "txtContent": "=[$Author.title] + ' - ' + [$Category]"
}

enter image description here

Note:

  • "$Author" is the internal display name of [Created By]

enter image description here

  • The JSON column formatting does not change the data in the columns; it only changes how it’s displayed to users who browse the list. Therefore, the actual value of [Title] is not "Created By - Category".

enter image description here

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.