How to use formulas in SharePoint lists

https://youtu.be/vHrIuoWdBMk
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
#sharepointlists
#lists

Join this channel to get access to perks:
https://www.youtube.com/channel/UC1c7NBQ7tjBhPGegvCXid_A/join

If you want to support me, check this out: https://www.patreon.com/itseasy

Online training courses:

https://itseasytraining.teachable.com/
https://www.udemy.com/course/microsoft-excel-intermediate-course-z/?referralCode=365DF21869A9F9D2BFCB
Playlists for this channel:

Access: https://www.youtube.com/watch?v=WyFj2eeMfSI&list=PLK99llucAWls71sYcwuXUGuTB33Iz4sFP&ab_channel=ITsEasyTraining1st

Excel: https://www.youtube.com/watch?v=yKobsDbGbyM&list=PLK99llucAWlt5BjHVQwlzFWcqtOR0xMsc&ab_channel=ITsEasyTraining1st

Word: https://www.youtube.com/watch?v=1yB2yP_5LQ0&list=PLK99llucAWlvAvYnQHbuqPzahwXC2GP5T&ab_channel=ITsEasyTraining1st

Visio: https://www.youtube.com/watch?v=ucHD0C4xeBY&list=PLK99llucAWlubxRVLca37R6Jh4jSZyxC3&ab_channel=ITsEasyTraining1st

Project: https://www.youtube.com/watch?v=5Fmgei_PagI&list=PLK99llucAWltWM3-Ohg_V1d6Q0STPAzG7&ab_channel=ITsEasyTraining1st

PowerPoint: https://www.youtube.com/watch?v=fOhiNLAzVAQ&list=PLK99llucAWluWCI4_xLnfbjm5GpAZo9Ye&ab_channel=ITsEasyTraining1st

Publisher: https://www.youtube.com/watch?v=I1-DPJTSvg4&list=PLK99llucAWlvCyOwrQh-OSlPpXWBIEVYq&ab_channel=ITsEasyTraining1st

OneNote: https://www.youtube.com/watch?v=JS5Y_BSEbgg&list=PLK99llucAWlteO7uOpQHz5rOBCdnZ0YMD&ab_channel=ITsEasyTraining1st

Office 365: https://www.youtube.com/watch?v=fphQ0jmv0-8&list=PLK99llucAWlv0L0K0wsLW_S5VkOHFuxli&ab_channel=ITsEasyTraining1st

#itseasytraining

Classroom based courses can be arranged at https://www.itseasy.co.uk/

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

Online courses at https://itseasytraining.teachable.com/

Udemy Courses https://www.udemy.com/user/stephen-saxton/

Training Guide Books

Excel for New Managers

Microsoft Project Overview https://www.amazon.co.uk/Microsoft-Project-Overview-need-about/dp/1705474632

Microsoft Visio Basic https://www.amazon.co.uk/Microsoft-Visio-Basics-Stephen-Saxton/dp/B089CSJBMD

Very cheap E_books are here:
Excel For New Managers https://payhip.com/b/IE4x
Microsoft Project Overview https://payhip.com/b/wY0m
Microsoft Visio Basics https://payhip.com/b/5XeV
Microsoft Access Introduction https://payhip.com/b/ynSL
A PowerPoint Overview https://payhip.com/b/YkQv

---