Create a SharePoint List in Microsoft 365: Using Data Types & Calculated Columns
Learn how to create a powerful SharePoint list from scratch within Microsoft 365! This step-by-step tutorial guides you through setting up a new SharePoint Online list, adding columns with various data types (like Text, Number, Date & Time, Choice, Person), and leveraging calculated columns to automatically derive information.
In this video, you'll learn:
How to create a new list in modern SharePoint Online.
Choosing the right data types for your columns (Single line of text, Multiple lines of text, Number, Currency, Date and Time, Yes/No, Person or Group, Choice, Lookup).
Understanding and creating basic calculated columns using SharePoint formulas.
Practical examples of calculated columns (e.g., calculating a due date, concatenating text).
Perfect for anyone needing to organize data effectively in Microsoft 365 using SharePoint lists. Stop managing data in spreadsheets and start using dynamic SharePoint lists!
#SharePoint #Microsoft365 #SharePointList #CalculatedColumns #SharePointTutorial #Office365 #DataManagement
Demo Share point list:
Building Code/ID:
Type: Single line of text
Description: Unique identifier for each building.
Location/Address:
Type: Single line of text
Description: Physical address or location of the building.
Type:
Type: Choice
Choices: Camp, Rented Villa, etc.
Description: Type of building.
Total Capacity (Beds):
Type: Number
Description: Total number of beds available in the building.
Current Occupancy (Count):
Type: Number
Description: Current number of occupants in the building.
Current Occupancy (%):
Type: Calculated
Formula: =[Current Occupancy (Count)]/[Total Capacity (Beds)]*100
Description: Percentage of current occupancy.
Status:
Type: Choice
Choices: Active, Inactive, Under Maintenance
Description: Current status of the building.
Linked IN: / elango-shunmugaraj-11113a76
Github: https://github.com/codeofelango?tab=r...
Site:https://sites.google.com/view/thescho...