how to use formula in the List's title coloumn

2011-06-03

Question

_{Friday, June 3, 2011 12:41 PM}

my list has a default coloumn with name as Title, and two more coloumns firstname and lastname.

i want to set Title to a formula so that it appends firstname + " " + lastname.

how do i do it?

All replies (16)

_{Friday, June 3, 2011 12:55 PM ✅Answered | 1 vote}

ok you need to do the following as you cannot achieve what you want by default.

1. Change the title column to not be a required field
2. In advanced settings in the list/library settings, choose to Allow Management of Content Types
3. Now go into the content type and hide the column title, so that when you add a new item, you only add the first name and last name

Ok your set now to use SharePoint Designer to create a very simple workflow to do what you need.

1. launch sharepoint designer and create a new workflow working on the list in question
2. Set the workflow to start when an item is created or edited
3. Set the workflow to have NO conditions and the ACTION to be set field in current item
4. Set FIELD to be the Title field
5. Set VALUE to be the concatenation of the first name and last name, do this by clicking the ... icon (Display Builder for the parameters) and then adding in the fields you require.

Now when you add an item, you will only be presented with the option to add a first name and last name, when you save a workflow will run and you will now have a title field which is first name and last name.

_{Thursday, June 9, 2011 1:44 PM ✅Answered | 1 vote}

No. That's what calculated column is used for. This ref is 2007 but there may be an equivalent for 2010:
http://office.microsoft.com/en-us/windows-sharepoint-services-help/introduction-to-data-calculations-HA010121588.aspx
Quote: "You cannot reference another column in a formula that creates a default value for a column."
AK

_{Friday, June 3, 2011 12:53 PM}

you can't apply forumla to tile column. It's a SHP build in column

Better it's to create your own column, calculated based on [firstname]&" '&[lastname]

If you don't 'like' title column, you can hide this column

romeo donca

_{Saturday, June 4, 2011 5:00 AM}

ok you need to do the following as you cannot achieve what you want by default.

1. Change the title column to not be a required field
2. In advanced settings in the list/library settings, choose to Allow Management of Content Types
3. Now go into the content type and hide the column title, so that when you add a new item, you only add the first name and last name

Ok your set now to use SharePoint Designer to create a very simple workflow to do what you need.

1. launch sharepoint designer and create a new workflow working on the list in question
2. Set the workflow to start when an item is created or edited
3. Set the workflow to have NO conditions and the ACTION to be set field in current item
4. Set FIELD to be the Title field
5. Set VALUE to be the concatenation of the first name and last name, do this by clicking the ... icon (Display Builder for the parameters) and then adding in the fields you require.

Now when you add an item, you will only be presented with the option to add a first name and last name, when you save a workflow will run and you will now have a title field which is first name and last name.

there is some thing like formula when u edit properties of TITLE field..what is that?

_{Saturday, June 4, 2011 5:02 AM}

Use a workflow that sets the Title to the dynamic string of "FirstName LastName".SharePoint Architect || Microsoft MVP || My Blog
Planet Technologies || SharePoint Task Force

_{Saturday, June 4, 2011 5:03 AM}

"there is some thing like formula when u edit properties of TITLE field..what is that?"

What does this question mean??

SharePoint Architect || Microsoft MVP || My Blog
Planet Technologies || SharePoint Task Force

_{Saturday, June 4, 2011 5:51 AM}

"there is some thing like formula when u edit properties of TITLE field..what is that?"

What does this question mean??

SharePoint Architect || Microsoft MVP || My Blog
Planet Technologies || SharePoint Task Force

sorry i got it wrong.. there is a calculated value field inside Properties of Title..maybe we can set some formula into this ?

_{Saturday, June 4, 2011 9:34 AM}

how to use CALCULATED VALUE property of List's TITLE (column) field?

_{Saturday, June 4, 2011 12:42 PM}

_{Saturday, June 4, 2011 3:53 PM}

Where is there a calculated value field inside the properties of Title? The Title field has no properties when you click on it.SharePoint Architect || Microsoft MVP || My Blog
Planet Technologies || SharePoint Task Force

_{Saturday, June 4, 2011 4:08 PM}

Why did you make another thread on this same topic, and why are you not explaining exactly what you're talking about? The Title field has no properties to set for calculation. If you are talking about something else deep in the XML, then please explain exactly what you're talking about. Also, people have given you an answer, and you've dismissed it completely. That is not how to use the forums. YOu ask tons of questions as if you think you deserve to be given free answers to everything you don't know how to do, but that is not how this forum works. People are spending their FREE time giving you FREE support so you can go make money with your clients, yet you dismiss responses as if people didn't even reply.

Do not continue to behave like that.

SharePoint Architect || Microsoft MVP || My Blog
Planet Technologies || SharePoint Task Force

_{Monday, June 6, 2011 4:40 AM}

Why did you make another thread on this same topic, and why are you not explaining exactly what you're talking about? The Title field has no properties to set for calculation. If you are talking about something else deep in the XML, then please explain exactly what you're talking about. Also, people have given you an answer, and you've dismissed it completely. That is not how to use the forums. YOu ask tons of questions as if you think you deserve to be given free answers to everything you don't know how to do, but that is not how this forum works. People are spending their FREE time giving you FREE support so you can go make money with your clients, yet you dismiss responses as if people didn't even reply.

Do not continue to behave like that.

SharePoint Architect || Microsoft MVP || My Blog
Planet Technologies || SharePoint Task Force

i have dismissed it as i did not wwant to create a workflow.. this is because when i look into the properties if the TITLE field, i can see a radio button for CALCULATED VALUE.. if the answer is as simple as that, then i wouldnt like to create a workflow.. and if there is no other way out, then i will use a workflow..

ok my mistake..sorry. but can u tell me what is that calculated field usede for?

i am pasting the image link so that u can have a look:-

http://tinypic.com/r/2qxojzk/7

Why did you make another thread on this same topic,

in my 2nd topic, i askd specifically about the TITLE property(calculated field).

why are you not explaining exactly what you're talking about?

iv tried my best to explain.

The Title field has no properties to set for calculation. If you are talking about something else deep in the XML, then please explain exactly what you're talking about.

title field properties does have a calculated value textbox..please have a look at that.

Also, people have given you an answer, and you've dismissed it completely.

**i did not dismiss it, u r taking things in a very negative manner, its just that it was another way around.**That is not how to use the forums. YOu ask tons of questions as if you think you deserve to be given free answers to everything you don't know how to do, but that is not how this forum works. People are spending their FREE time giving you FREE support so you can go make money with your clients, yet you dismiss responses as if people didn't even reply.

ok it was an anaswer .. my mistake .

_{Thursday, June 9, 2011 12:34 PM}

what is the purpose of Calculated value under properties of TITLE field of any LIST?

_{Thursday, June 9, 2011 1:14 PM}

if you mean the column properties of the Title, default value: text or calculated value, you could set a default value in case you want it set according to some business rule or if an automated process creates list items (ex. order no - current date).
AK

_{Thursday, June 9, 2011 1:17 PM}

if you mean the column properties of the Title, default value: text or calculated value, you could set a default value in case you want it set according to some business rule or if an automated process creates list items (ex. order no - current date).
AK

suppose if my list's custom new form has input boxes to enter 2 values,

value1= 5

value2=10

can i use the calculated value property on title and say =value1+value2?

_{Friday, June 10, 2011 6:32 AM}

No. That's what calculated column is used for. This ref is 2007 but there may be an equivalent for 2010:
http://office.microsoft.com/en-us/windows-sharepoint-services-help/introduction-to-data-calculations-HA010121588.aspx
Quote: "You cannot reference another column in a formula that creates a default value for a column."
AK

thanks abed

Share via

how to use formula in the List's title coloumn

Question

All replies (16)

Additional resources