SharePoint List Title Field - Calculated Value

Hi Tiffany Shotts,

I am very sorry that you did not receive the response about "Calculated Value".

I have found some information that may be helpful for you, please refer to it and let me know your opinion.

The "Calculated Value" option in SharePoint is part of the Calculated Column feature, which allows you to create a column in a list or library that automatically computes its value based on a formula. This is similar to using formulas in Excel.

What is a Calculated Column?

• Uses a formula to compute values based on other columns in the same list or library.
• Can return different data types like text, number, date/time, currency, etc.
• Automatically updates when the referenced column values change.

Please understand that our initial response does not always answer the question immediately. However, with your help and more detailed information, we can work together to clear it.

If my answer is helpful, please mark it as an answer, which will definitely help others in the community who have similar queries.

I hope this information is helpful.  

Looking forward to hearing from you.    

Best Regards,        

Kai Vo - MSFT | Microsoft Community Support Specialist

I can create calculated columns - i am trying to find information on how to use the "calculated value" default option in the Title field.

Hi Tiffany,

Based on my research, I’ve found some information that may be helpful.

In SharePoint online, it's not supported that formula contains reference to other fields when setting column default value. Only calculated column can contain other columns.

If you insert the formula

=Me&" - "&TEXT(Today,"dd-mm-yyyy")

into your calculated value, you should get something close to what you want.

For example:

After that, I go to my list and click Add new item

Automatically add to my title.

Be aware though that at any time the user can insert something else into the field.

To get around this, you could either create the list from scratch and hide the site column or insert the value using an event handler in the Item Updated event (more on event handlers)

I hope this information is helpful.  Feel free to reach out if you have any questions.

If my answer is helpful, please mark it as an answer, which will definitely help others in the community who have similar queries.

Looking forward to hearing from you.    

Best Regards,        

Kai Vo - MSFT | Microsoft Community Support Specialist

Hi Tiffany,

Is there any update from you? If yes, please feel free to let us know.

Best Regards,        

Kai Vo - MSFT | Microsoft Community Support Specialist

Hi Tiffany,

If my answer helps, please mark it as an answer, it will definitely help others in the community with similar queries to find a solution to their problem faster. On top of that, it helps me have a good survey and makes me do my best.