How to Create Calculated Columns on a SharePoint List

In this session, Jonathon Silva from Pragmatic Works continues his SharePoint Basics series by walking through how to build calculated columns inside a SharePoint list. He explains the process step by step, showing how organizations can streamline data entry and automate simple calculations directly within SharePoint without needing external tools.

Why Use Calculated Columns?

Calculated columns allow users to automatically perform calculations or generate values based on other columns within a list. Instead of relying on manual math or external spreadsheets, SharePoint can dynamically handle totals, projections, and reminders for better efficiency. In this example, Jonathon demonstrates three calculated columns:

• Build Cost – the total cost of producing a project.
• Final Price to Client – a projected selling price or MSRP based on the build cost.
• Final Check-In Date – a reminder date set 14 days before the project due date.

Navigating to List Settings

To begin, Jonathon opens the List Settings in SharePoint. This is accessible through the gear icon in the top right corner. From there, users can select List Settings and scroll to the bottom to create a new column. When creating a column, SharePoint provides multiple data types. For this tutorial, the focus is on the calculated type, which builds values based on other columns.

Creating the Build Cost Column

The first calculated column is Build Cost. Jonathon demonstrates how to use Excel-like formulas inside SharePoint:

1. Select Create Column.
2. Name the column Build Cost.
3. Choose Calculated as the column type.
4. Enter a formula using existing fields. For example:

   =SUM([Labor Cost],[Parts Cost])

5. Choose the return type (e.g., currency with two decimal places).
6. Click OK to save.

By referencing existing columns in brackets, users can quickly create formulas that feel very similar to Excel, Power BI, or Power Automate.

Adding the Final Price Column

The second column calculates a Final Price to Client (or MSRP). This column uses the Build Cost as a base value and applies a markup factor. Jonathon demonstrates the following steps:

1. Create another calculated column called Final Price.
2. Enter the formula:

   =[Build Cost]*1.8

3. Set the return type to currency.
4. Save the column.

In this case, a markup of 80% was used, but organizations can set their own percentage. The flexibility allows quick adjustments for project pricing, quotes, or internal tracking without having to open a separate tool.

Creating the Final Check-In Date

The last column focuses on project management and reminders. Jonathon creates a Final Check-In Date, which is two weeks before the due date of a project. Steps include:

1. Create a calculated column called Final Check-In Date.
2. Use a formula subtracting 14 days from the due date:

   =[Due Date]-14

3. Select Date Only as the return type.
4. Click OK to save.

This automated reminder is especially useful for teams who want a buffer period before project delivery. It can also be integrated into Power Automate flows to send reminder emails automatically.

Viewing Results in the SharePoint List

After creating the three calculated fields, Jonathon navigates back to the list to confirm the results:

• Build Cost correctly adds together Labor Cost and Parts Cost.
• Final Price reflects the calculated markup based on Build Cost.
• Final Check-In Date shows the date 14 days before each project due date.

If columns are not immediately visible, users can select Show/Hide Columns to make them appear in the view. Jonathon highlights that once these are in place, teams have immediate insights into cost, price, and scheduling without additional effort.

Key Takeaways

Jonathon emphasizes that calculated columns in SharePoint are straightforward to set up and highly effective for automating routine tasks. The main points include:

• They reduce manual calculations by embedding formulas directly into lists.
• They use familiar Excel-like syntax, making them easy to learn.
• They improve project visibility with built-in cost, pricing, and scheduling logic.
• They can integrate with Power Automate for workflows such as automated reminders.

Overall, calculated columns are a powerful tool for enhancing SharePoint lists. By leveraging basic formulas, teams can improve accuracy, reduce repetitive work, and make their lists more functional.

Don't forget to check out the Pragmatic Works' on-demand learning platform for more insightful content and training sessions on SharePoint and other Microsoft applications. Be sure to subscribe to the Pragmatic Works YouTube channel to stay up-to-date on the latest tips and tricks.