In this SharePoint tutorial, we will discuss on SharePoint list view, how to create a list view in SharePoint Online modern site as well as in classic site.
Also, we will see how to display SUM Total in SharePoint list views.
SharePoint Online modern experience introduced a new way to create Views more quickly. In SharePoint 2010/2013 classic experience, we can create Views in a traditional way that takes time but in SharePoint Online, Microsoft introduced a new way of creating Views. Let us explore how to create a View using this new feature in Modern sites and Classic SharePoint sites.
Here I have a created a custom SharePoint list as “Employee information” which has few columns and the list looks like below:
In modern SharePoint site, users can’t quickly create a View on the location and skill-based filter in a traditional way.
We overcome the limitation of the SharePoint List View using the new feature of SharePoint Online.
Create a View on location and skill-based filter in SharePoint list
Open the list in “All items” view and apply the filter on location and skills column. Then, click expand All Items and select the save view as option like below:
Then it will show a popup, where you can give a view name and click on the Save button like below:
Finally, the SharePoint Online list view will looks like below:
Now, we will see how we to create the same fiter view using SharePoint Online classic experience.
Here, I have created a custom list, “Employee information” which looks like below:
In classic SharePoint site, the users can’t quickly create a view on the location and skills-based filter in a traditional way.
We overcome the limitation of the SharePoint list view using SharePoint 2013 new feature.
Create a view on location and skills base filter
Open the list all items view and apply the filter on location and skills column and click on SAVE THIS VIEW hyperlink.
After selecting SAVE THIS VIEW Hyper link the below pop screen appears. Set the view name and click on the Save button.
Finally the classic SharePoint list view will look like below:
Here we will see how to create list view styles in the classic sites. There are 8 ways to create list view styles
- Basic Table
- Boxed, No labels
- Newsletter, no lines
- Preview Pane
To edit the list view in classic SharePoint site, Open list in classic site-> Click on All items view -> Select Edit current view -> Go to bottom of the Edit view page->Select Style hyperlink-> choose view styles( as per your requirement)-> Click OK.
We will see the above list view styles by creating a list(e.g. Project management list) in SharePoint classic site. And also it is a Default view i.e. All Items view.
This view is similar to default view but add new item link is shown just below the view.
Boxed, No labels
This SharePoint view provides card view, and also labels are not there with the value.
This SharePoint view is similar to the above view, here labels are there with the value.
This SharePoint style view, display the information one below other.
Newsletter, no lines
This SharePoint view is similar to the above view, the only changes instead of line row is separated by shaded bar.
This SharePoint view style is similar to the basic table view, the only difference is Shaded color in alternate row.
This SharePoint view style having two parts: one each title column is listed and the other display values of the other columns when you hover over the Specific title column. This view takes less space to present.
The above are the examples of SharePoint list view styles.
Let us see, how to group a SharePoint document library by year created in SharePoint 2013/2016/2019/Online
Open the SharePoint document library and then go to the LIBRARY tab and then click on Settings Icon and then Library Settings. Then go to the Columns and click on Create Column.
Then give the Column name and chose the calculated column and then in the Formula box type =Year(Created). Then The data type returned from this formula is Number as shown in the fig below:
Now go to the Views section and then click on Create View and then Choose Standard View from the view type. This will open the Create View page. Give a name for the view.
Then go to the Group By and then the First group by the column: select the column name which we have created. It will appear like below:
Then click on OK and now check the view it will appear like below:
Similarly, if you want to do a group by based on month-wise then while creating the column (calculated column), in the formula write like below:
And the list view will appear like below:
In this case, create 2 columns one for a month and one for a year like above. Also, use the same formula which we have written above. Now got to the view and then go to the Group By and there give on Year in the first and Month in second like below.
Now it will appear like below:
Let us see, how to group SharePoint document library by Year and Month Created in SharePoint 2013/2016/2019/Online.
This SharePoint customization tutorial we will discuss how to show sum total in SharePoint 2013/2016/Online list view by using out of box feature.
In this example, I have a SharePoint 2013/2016/Online custom list which has two Number fields as Age and Salary. The list looks like below:
Here I want to see a Sum of Age and Sum of Salary Column in the SharePoint list view.
For this Open the SharePoint list view in the browser, then go to List tab in the Ribbon and then click on Modify View like below:
This will open the Modify List view page. In this page navigate to the Totals page and expand that.
Then for the particular column choose Sum from the drop-down under Total. The option will come according to the column data type.
Let’s say Sum will appear for Numeric data type columns. But for single line data types column, Sum option will not appear.
It should look like below:
Now click on OK and then you will be able to see the Sum in the list view like below:
Now, we will see how to remove “Sum=” text from SharePoint 2013 list view. Here I have a SharePoint 2013 list where I have a Salary column. I am displaying the total Sum for the Salary column by following this article.
Here below to the Salary column, the sum is displaying as Sum=37,000.00. It displays like below:
But my requirement is to remove the “Sum=” text, I just want to display the total sum.
Now you will not able to see the Sum= text. It only shows the total sum.
Let us see, how to show paging at the top in the list view web part in SharePoint 2013 online or SharePoint on-premise.
By default in SharePoint 2013 Online or SharePoint on-premise paging for list or document library shows at the button of the page. It looks like below:
Show paging at top in list view web part in SharePoint
You can edit the page which contains your list or document library. Then add a script editor web part into the page and add the below code into the page.
After this Save the page and now you can see the paging button will appear in the top of the list view web part.
This is how to show paging at the top in list view web part in SharePoint 2013/2016/Online using jQuery.
By default, if you have multiple list view web part in page sometimes you will be able to see the Files and Libraries tab in the ribbon for document libraries. Or if you have listed in the page you may not see the ITEMS & List tab.
After you select the list view web part then the tabs for the corresponding list or libraries appears. Recently in one of my site few business users come saying we were not able to see the Files and Libraries tab then how could we upload the document.
First, we have a solution saying select a row then ribbon will appear but something they do not want to do like that.
So whenever they open a page list view ribbons options do not come like below:
Then we got one solution from MSDN which works perfectly for us.
Show Ribbon for ListViewWebPart on Page SharePoint
Just put the below code in a script editor web part in the page in SharePoint.
MSOZoneCell_WebPartWPQ3: Here for the particular web part zone you can get the id by using firebug or by inspecting element in chrome browser.
Once we put the code and save the page, it appears like below:
Hide approved task list Items in SharePoint Online
Let us see how to hide approved task list items in SharePoint Online.
Here, we will first create a SharePoint task list and then we will modify the existing All Task list view.
Step 1: Login to the SharePoint Online site -> Go to the Site contents -> Create a New Task List
Step 2: Next go to the SharePoint List Settings -> Go to the Views Section and click on All Tasks
Step 3: Next go to the Filter Section and change the settings as below and save the view.
Here is the filter for Show items only when the following is true:
Task Status is not equal to Completed.
Step 4: Next Open the SharePoint list and see, the approved tasks will not appear in the SharePoint list view.
In the same way, you can also hide task items, Not Started Items and In Progress Items in the Task List.
The changes I have done in the All Task list view, even you can create your own custom list view and add the changes.
Let us see, how to hide expired announcements in the SharePoint Online list view.
Let us see how to hide announcement which has already expired in SharePoint Online or SharePoint 2013/2016/2019.
Log in to the SharePoint Online site -> Go to the Site contents -> Create a New Announcement.
Here I have created a new column called Announcement Date.
In this step, we have to do hide the list items that have already expired so we have to verify with the current date.
For this, we can simply create a SharePoint list view.
So go to the List settings -> Go to the View Section -> Click on All Views.
Next, go to the filter section and update the formula as below.
Next, Save the list view and see the output now, all expired tasks are not appearing in the SharePoint list.
Note: The same way you can do for the previous date and future date based on the condition as below.
This is how to hide expired announcements in SharePoint Online by simply creating a list view.
You may like the following SharePoint tutorial:
- PowerShell SharePoint list operations
- SharePoint list operations using rest api
- SharePoint modern list view customization example
- SharePoint list title column remove
- SharePoint custom list example
This is a good feature in SharePoint Online to create list views on the fly. Here we saw how to create SharePoint list view.
Solutions. I am currently working on Sharepoint 2010, MOSS 2007, Sharepoint 2013,Sharepoint 2013 App Dev, C#, ASP.NET, and SQL Server 2008.