Using Calculated Columns

Wouldn’t it be great to have a column within a SharePoint list that automatically populated itself with the content from other, separate columns from the same list? This LinDion Services performance support item will leverage our Learning Catalog SharePoint list as an example, which applies to any list.

Once again, imagine that within one of your lists, you’re capturing information in two separate columns and need them to be separate for specific reasons.  However, you also need to combine the information from both into another, separate column.  For example, seen below, we need to capture the LMS Category (Column A), the LMS Number (Column B) and then have both the LMS Category and LMS Number columns merge together in a new column (Column C).  Imagine having to enter that information in column C manually.  Using a Calculated column, you can avoid re-entering this information manually (see below).

MS-SharePoint: Using Calculated Columns (Results)

INSTRUCTIONS: Create a Calculated Column and Add the Formula

Within your list, create a new Calculated column (in this case, Single line of text) and double-click on the columns to reference or rather leverage from the Insert Column: add the ampersand (&) sign in between both to create the following formula (as an example): =[LMS Category]&[LMS Number].

MS-SharePoint: Using Calculated Columns (Instructions to Add the Formula)

From the Help icon in SharePoint, access “Examples of common formulas” to learn more about possibilities with the Calculated column.

Please contact us with any questions.

Download "Using Calculated Columns"