Adding Calculated Columns | SharePoint Tutorial pdf

Adding Calculated Columns

Use calculated columns to bring together values from other columns. For example, the Phone List contains a Full Name column that is a single line of text. Since the list already has First Name and Last Name in it, it makes more sense to create Full Name out of those two columns. 

To do that:
1. On the Phone List toolbar, click Settings®Create Column. SharePoint displays the Create Column page.
2. Complete the page as shown in Figure and click OK. The formula shown in Figure is =[First Name] & “ “ & [Last Name]. SharePoint adds a new calculated FullName column to the list.
Figure: Adding a calculated column to a list

To get help using formulas, display the SharePoint Help and click Formulas and functions. To display SharePoint Help, use the following
link: ./_layouts/help.aspx?Key=NavBarHelpHome
Notice that I told you to name the column “FullName”. The Phone List already has a “Full Name” column and you can’t have two columns with the same name! We’re not using the Full Name column, so let’s delete it. To delete a column:
1. On the list toolbar, click Settings®List Settings. SharePoint displays the Customize page.
2. Scroll down and click Full Name in the Columns list. SharePoint displays the Change Column page.
3. Scroll to the end of the page and click Delete. SharePoint warns you that data for this column will be deleted. Click OK to delete the column.