When was the last time you went to the grocery store? For me it’s a weekly thing. Anytime I go, I’ve got a shopping list. It’ll usually look something like this:
|Dog Food||Purina Healthy Weight||12.69||No|
Using the grocery list as an example, we can see that there are four columns to this list (Name, Description, Price, and A coupon field). Each column in the grocery list above captures a specific type of information, whether it’s a small amount of text, a number, or a Yes/No. The list item details are captured in the columns. We wouldn’t put a person’s phone number and address into a shopping list– we would put it into a directory, or contact list.
SharePoint lists work exactly the same way. A SharePoint list is a collection of pieces of information– all of which have the same properties. In the same way that sites are created for the express purpose of achieving a specific goal, lists are a way of capturing related information in a specific-fashion. SharePoint lists have “Column Types” that specify what information you’re capturing in a list.
- Single line of text
- Multiple lines of text
- Choice (menu to choose from)
- Number (1, 1.0, 100)
- Currency ($, ¥, €)
- Date and Time
- Lookup (information already on the site)
- Yes/No (check box)
- Person or Group
- Hyperlink or Picture
- Calculated (calculation based on other columns)
- Task Outcome
- External Data
- Managed Metadata
This may seem like a lot of information and you may not recognize some of the terms in the column types list, but, chances are if you don’t know what it is, you probably wont have to use it. I’ll go into more detail on column types in the video.
Here’s some uplifting news, any built-in “App” in SharePoint will be a slight variation on the concept of a list. So if you understand the concept of a list, you’ll comprehend about 60-80% of what SharePoint does.
Did Someone Say Excel?
Also, lists can also be exported and opened in Microsoft Excel—with a button right on the screen! Later on, I’ll show you how we can use lists and all of the features within them to make some powerful tools to help you work more efficiently!