10 Tips to Creating Great SharePoint Views on Lists & Libraries

SharePoint data

10 Tips to Creating Great SharePoint Views on Lists & Libraries

By Tracy van der Schyff | January 30, 2018

Views in SharePoint are similar to reports on data. The better the reports, the better the consumption of the data. As we work with so much information, we can get to what we’re looking for faster and become more efficient.

In this blog post, I’ll share the top 10 tips to help you make the most out of creating and using views in SharePoint Online Document Libraries and Lists.

SharePoint Views on lists and libraries

Tip #1: Never edit the default view.

List and libraries in SharePoint are created with a default view. It’s either All Items or All Documents.

I have a rule to never edit these default views. It sounds crazy, but believe me, I’ve broken a default view and then struggled to view the content again. I’d much rather create a view and edit that view, leaving the SharePoint default view as is. That way, I always have a “untouched” view to fall back on.

To create a new view:

  1. Click on Settings
  2. Select Library Settings (or list settings)

Create a new SharePoint view

At the bottom of the Settings page, you’ll see the views. Click on Create View:

Create View setting

You now have templates to choose from.

  1. Standard View is similar to the All Documents view you get with the app.
  2. Datasheet View displays data in the Quick Edit view.
  3. Calendar View is for items that have start and end dates. There are also other column requirements, and they are best used for Calendars and Tasks.
  4. Gantt View is a great view to use on Task Lists.

Initially, it’s easier to copy an existing view (as you already know what it looks like). Click on Start from an existing view > All Documents:

View Type on SharePoint

Tip 2: Understand the different settings.

Note: Some of these settings are not working yet in the new modern libraries and lists. If the setting is not working as expected, keep in mind that Microsoft might be updating the settings on views. These tips can be applied to your SharePoint 2010, 2013, and 2016 environment as well.

Name

First, you need to name the view. It’s important to choose a name that makes sense to other people.

When creating grouped views an example would be: “Department > Document Type.” You also have the ability to change this new view to the default view. The default view will open when clicking on the app in Site Contents, or clicking on the recent item App name in the Quick Launch.

Document Type on SharePoint

 

Depending on your permissions, you will be able to create personal or public views. Most users can only create personal views which are for their own use.

Create a Public View on SharePoint

 

Columns

Choose the columns you would like to display. For document libraries, I always switch on the “File Size” as well as “Checked Out To” Columns. Here, you can also set the order of the column on the page in the view.

Column settings on SharePoint

Sort

Sorting indicates the order in which the data will appear. When using Groups, this applies to the groups, as well as the data expanded within the Groups.

Sort settings on SharePoint

Filter

Filters are great for creating views that should only show specific data. For example, a library or list has multiple items belonging to different departments. Create the view to only show data “when Department = Marketing.”

Filter settings on SharePoint

Tabular View

The ability to select multiple items at once.

Tabular View on SharePoint

Group By

Think folders: Groups are the best way to group data together based on metadata. Here, you’ll set the number of groups to display at a time as well.

Group By setting on SharePoint

Totals

Depending on the data you have in the column, Totals will allow you to Sum, Count, Average, etc. the data in the column. Some of these Totals only work in Datasheet view. Some totals are currently not working in the new modern lists and libraries.

Totals on SharePoint

Style

Style allows us to change the way the data is presented. These styles are currently not working in the new modern libraries and lists.

Style settings on SharePoint

Folders

Now, this is a great setting. It lets you see documents “outside of folders.” I’ll explain in more detail in a tip later on in this post.

 Folders on SharePoint

Item Limit

That annoying “next 30” link at the bottom of your page can be fixed by changing this. Keep in mind that if you display too many items, the page might take very long to load.

 Item Limit on SharePoint

Mobile

This is specifically related to viewing the library or list on a mobile device. I always leave it on 3.

Mobile settings on SharePoint

Tip #3: Understand your users.

We have the ability to create public and personal views. I always teach my users to create their own personal views, but it is important to launch the app with the minimum “necessary” views. Speak to the users and ask them what they would like to see. How do they find content?

Each view has its own unique URL, which means you can add links from other places to specific views. For example, on your Marketing site you can add a link that goes to the filtered view of the Policies library, which only shows Marketing policies.

Tip #4: Grouped Views

The views I create most are grouped views. For example, when not using folders, and users want to see their content grouped by category, then this is the way to do it.

You would first have to add metadata columns to your app. I’ve added Departments and Document Types. Below you’ll see the setting when creating the view:

Grouped Views on SharePoint

Here’s the end result:

Grouped View

Note: Did you know you can drag documents with no metadata to a grouped section in the view and it will update the metadata?

Tip #5: Views without Folders

The only time I use these views are when I add permissions on folder level. This means I can have multiple folders with documents and each folder can have different permissions, which apply to that folder and the content inside.

Of course, you’ll have people that have access to multiple folders. This is a great way to create a view where they see all content they have access to.

In the settings of the view, choose “Show all items without folders:”:

Show All Items without Folders on SharePoint

Here’s the normal view with the document displaying inside the “Test Folder”:

Test Folder on SharePoint

In this screenshot, you’ll see the same document lying between the other documents (without the folder):

Without Folders View on SharePoint

Tip #6:  Filtered Views

Filtered views are great for displaying a selection of the data.

Imagine libraries with thousands of documents belonging to different departments and document types. I build libraries like these for the controlled documents on Intranets. They contain the Policies, Procedures, Forms, and Templates for various departments.

For example, to create a view that only shows policies, you will add the filter in the settings of the view, the text (typed) needs to be exact:

Filtered Views on SharePoint

In the modern libraries and lists, you can also apply the filter on a view, then save it as a view.

Apply the filter:

Filter By setting on SharePoint

Save the view:

Save View setting on SharePoint

Here’s an example of a filtered view (Policies) which groups the content by Department:

Department Filtered View setting on SharePoint

Be careful when creating filtered views that has more than two filters. You have to put the “absolute statement” last. In the example below, I require the view to return data where the score is either lower than two or greater than four and the department is equal to Marketing. SharePoint will test the first condition first – OR, then add the AND condition.

Conditional Filtering setting on SharePoint

Note: Once a filtered view is created, you can create filtered alerts. This means you’ll be notified if something changes on a specific subset of documents:

Filter notification on SharePoint

Tip # 7: Create Views with “Formulas.”

When working in libraries or lists with thousands of items, it helps to see your latest items. In this example, I’ll use the [Me] and [Today] formula. I’ve created it as a public view as anyone can use it.

Create a Public View on SharePoint

I then add the filter where Created By or Modified By is equal to [Me] and added AND where today’s date is equal to [Today]. See above tip on adding more than two filters on a library or list.

 View setting on SharePoint

Item-level permissions

Here’s another cool tip for lists in SharePoint: Go to the List Settings > Advanced Settings. Set the list to only allow a user to read and modify items created by themselves. Remember to give the administrators Approval or Designer rights so they can see everything.

Item-level permissions on SharePoint

Tip #8: Files that Need Attention

Files that need attention is a new default view that shows any items that require properties to be completed. I love the fact that it has a little red status indicator above the Views dropdown.

Files that Need Attention on SharePoint

Tip #9: Approve or Reject

Approvals is a great feature on Apps in SharePoint. This is OOTB (out-of-the-box) approvals without workflow and uses statuses for the approval of content. With the Approve/Reject View, users with correct approval permissions will be able to navigate to items which need to be approved.

Content will be grouped by status:

Approve/Reject Items on SharePoint

Tip #10: My Submissions

When content approval is switched on, the “My Submissions” view will display all your own items, grouped by approval status.

My Submissions on SharePoint

Conclusion

I do believe an app is only as good as the views you create to navigate the content. Users have a misconception about SharePoint, especially around libraries without folders (using metadata), that their content is in chaos and difficult to find.

Creating great views help users find content, faster, and teach them to create their own views.

Looking to Better Manage Your SharePoint Environment?

Making the most out of your SharePoint and Office 365 environment requires more than an out-of-the-box toolkit. See how Essentials for Office 365 can help you streamline your collaboration management strategy to better report on usage, manage users and content, and secure sensitive content.

Try a free 15-day trial of Essentials for Office 365 today.


Leave a Comment

Add new comment


Tracy van der Schyff

Tracy is a Microsoft MVP and an energetic, hyperactive adrenaline junkie who sees challenges and issues as opportunities and thrives on improving processes, environments and the general quality of life. Her broad knowledge about IT and Business gives her the ability to communicate on both levels and convey meaningful requirements and narrow the (ever present) gap between the two.

Written By: Tracy van der Schyff