SharePoint Calculated Columns

SharePoint Calculated Columns can be used to remove commas from number fields, open links in a new tab, categorize active items, display images, customize text, and do date or mathematical calculations.

Introduction to SharePoint Calculated Columns

How to create a new Calculated Column on a SharePoint list or library.

Calculated Column Examples

A list with screenshots of examples of Calculated Column formulas and how the column displays on the list or library.

Displaying number fields without commas

Using a calculated column you can remove the commas from number fields (1,000).

Column to group similar items together

Using a Calculated Column you can specify which items should be grouped together, for example maybe all Pending and In Progress tasks should be grouped as Active.

Creating Hyperlinks using Calculated Columns

You can create hyperlinks which you can even specify to open in a new tab using a calculated columns.

Fields missing from Calculated Column Insert Column

Some field types are not available to be inserted into a calculated column, these include checkboxes, multiple lines of text, person fields, hyperlinks, lookup, and managed metadata.



About Nick Hurst (85 Articles)
SharePoint and Nintex developer who strives to find easy to deploy and maintain solutions for business problems.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: