Create Calculated Columns for a List in SharePoint

In this blog post, we will put ourselves in the Power User’s shoes, and learn how to create calculated columns for a list in SharePoint.
This is also applicable to SharePoint Online, only a different interface (at the time of writing: Dec. 2017)

If you prefer to watch videos, you can browse my YouTube channel or specifically how to create calculated columns in SharePoint 2010 (same process).

 

Create the List

Log into your SharePoint site, and let’s create a list called “Client Orders“.

ClientOrdersList

Client Orders list

 

Create Custom Columns

We need to create custom columns for:

  • Customer
  • Order number
  • Product
  • Order date
  • Quantity
  • Unit price
  • Total due (calculated)

Note:
You can create Site Columns (like here), or only columns for this list (in List settings >> Create column)

 

Navigate to Site settings >> Site columns (under Web Designer Galleries)

 

Click Create at the top of the page, and choose as follow for each column:

Single line of Text + YES to “Require that this column contains information

  • Client Name
  • Order number
  • Product

Date and Time + YES to “Require that this column contains information

  • Order date

Number + YES to “Require that this column contains information

  • Quantity

Currency + YES to “Require that this column contains information

  • Unit price

Calculated + YES to “Require that this column contains information” + FORMULA

  • Total due

 

For the last column (Total due), once you select “calculated” in the type of column, enter the formula as below, and choose “currency” for data type to return:

Totaldue

Quantity * Unit price = Total due

 

Add those new columns to the list

Now we’re going to add those newly created columns to our Client Orders list.

  • Navigate back to the Client Orders list
  • Click List in the ribbon
  • Click on List settings (right hand-side)
  • Under the section Columns, click on “Add from existing site columns

Locate the new columns, select the column, and click “Add” in the middle (or double-click the column name to add it)

ColumnsAdding

Adding columns to the list

 

Once happy with that, click on “OK

 

ColumnsAdded

Columns added

 

ColumnsinList

New columns showing in the list

You can reorder the columns the way you like by modifying the view, or under the columns section in List settings.

 

Add items to validate the columns

Let’s add some orders to verify everything is working correctly.

  • Click on New Item
  • Fill the required fields
NewOrder

Adding an new order to the list

 

After clicking on Save, the list is updated, and the Total Due column is performing as expected!

ItemAddedCorrectly

Total Due column adding correctly

 

MoreOrders

More orders added to the list

 

Loading Likes...

Leave a Reply

Enjoying this blog? Spread the word to help others :-)

%d bloggers like this: