SharePoint Title column Calculated Value to reference other columns

Question

SharePoint Title column Calculated Value to reference other columns

Mcintosh, Rebecca 116

Hello!

Can anyone tell me what the Calculated Value should look like in the default Title column when I want it to reference another column please?

I have tried various options but I cannot get it to work - what is the right syntax for the calculated value to know I want to use my other columns?

Have tried:

=[ID]&"/"&[Code] (error with this)

="[ID]"&"/"&"[Code]" (this give me the actual value of [ID]/[Code]

User's image

1 answer

Your answer

Answer 1

Nam-D 1,600 Microsoft External Staff Moderator

Hello @Mcintosh, Rebecca,

Welcome to the Microsoft Q&A forum.

Based on the information you provided, it appears that you are experiencing an issue related to configuring a calculated column formula in SharePoint.

To set up the formula correctly, please follow the steps below:

Go to Library settings (or List settings).
Scroll down to Columns and select Create column.

User's image

Enter a column name and choose Calculated (calculation based on other columns).
In the Formula field, enter: =[ID] & "/" & [Code]

User's image

After saving the configuration, the “Title” column will automatically display the calculated result.
There is no need to set a default value for this column.

If you encounter any errors or have additional questions, please feel free to let me know. I look forward to hearing from you.

If the answer is helpful, please click "Accept Answer" and kindly upvote. If you have any further questions about this answer, please click "Comment".

Note: Follow these steps: Our documentation If you want to receive relevant email notifications for this thread, enable email notifications.

Mcintosh, Rebecca 116 Reputation points

2026-01-27T12:02:32.7933333+00:00

Unfortunately, this is not what I asked - I was hoping for direction on how to use the calculated value that is already part of the default Title column that comes with every SharePoint list as standard. Not a new calculated column.
Nam-D 1,600 Reputation points Microsoft External Staff Moderator

2026-01-27T13:30:38.1566667+00:00

Hello @Mcintosh, Rebecca,

Thank you for your prompt response.

At the moment, only Calculated column types support using formulas that reference data from other columns within the same list or library.

However, if you would like to automatically populate or update the Title column based on other fields, you can achieve this by creating a Power Automate flow. This approach allows you to dynamically set the Title value after an item is created or modified.

For more details, you may refer to the article: Update SharePoint List Items Using Power Automate

Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link

If you find this feature useful, we strongly encourage you to submit feedback and improve our services via the SharePoint · Community. This is the official channel where suggestions are reviewed by the product team and considered for future updates.

We truly appreciate your understanding and collaboration on this matter. Please feel free to share any additional details or questions you may have. We look forward to hearing from you soon.

Share via

SharePoint Title column Calculated Value to reference other columns

1 answer

Your answer