How to use formulas in SharePoint lists
In this video, you will learn how to use formulas in a SharePoint list to perform calculations, validations, and transformations on your data. Formulas are expressions that use operators, functions, and references to columns and values to produce a result. You can use formulas in calculated columns, validation settings, and default values. For example, you can create a formula that calculates the total price of an item based on its quantity and unit price, or a formula that checks if the due date of a task is past today. To create a formula, you need to follow some syntax rules and use the correct references for the columns and values you want to use. You also need to choose the appropriate data type for the result of your formula, such as number, text, or date. In this video, we will show you some examples of common formulas and how to apply them in your SharePoint list.

Views are ways of displaying the items in a list according to different criteria, such as filtering, sorting, grouping, and formatting
– Views can help you organize your data and find the information you need quickly and easily
– To create a view, go to the list settings and click on the “Create view” link
– You can choose from several types of views, such as standard, calendar, Gantt, or gallery
– You can also start from an existing view and modify it to suit your needs
– To modify a view, go to the list and click on the ellipsis (…) next to the view name
– You can change the name, style, columns, filters, sort order, grouping, totals, and item limit of the view
– You can also make a view the default view for the list or a personal view for yourself only
– To delete a view, go to the list settings and click on the view name under the “Views” section
– You can then click on the “Delete” button to confirm
– Be careful when deleting views as you cannot undo this action

Join this channel to get access to perks:

If you want to support me, check this out:

Online training courses:
Playlists for this channel:









Office 365:


Classroom based courses can be arranged at

Courses are available through Microsoft Teams, Online and Face to face in the UK

Online courses at

Udemy Courses

Training Guide Books

Excel for New Managers

Microsoft Project Overview

Microsoft Visio Basic

Very cheap E_books are here:
Excel For New Managers
Microsoft Project Overview
Microsoft Visio Basics
Microsoft Access Introduction
A PowerPoint Overview

Leave a Reply

You must be logged in to post a comment.


“Steve’s background in IT training clearly provided him with great organisational and managerial skills which he put to good use at Second Chance Enterprises. His ability to see the long term strategy as well as manage the day to day management is one of his biggest strengths.”

Chriss Graham
Project Coordinator at Daisy Group

“I studied with Steve when we completed our CiPD CTP together. During the course I found Steve to be very personable and also very professional.  Steve was first on my list of suppliers. Steve was very competitively priced and very accommodating.”

Simon Snowdon
European Training Manager at HP Enterprise Services

“Steve delivered a number of Microsoft Office Training Sessions to a range of employees across Newcastle College. The service provided by Steve is second to none. I have no hesitations in recommending him to other employers.”

Christine Jackman
Learning Manager(North) - Winner of Training Programme of the Year NECCA

“The course was really thorough and Steve was very knowledgeable and explained things very well. I’ve not used Microsoft Project before but now I feel very confident that I’ll be able to use it for what I need to do in my job”.

Craig Forster
Estimator, John F Hunt Regeneration Ltd