Rating Column in a SharePoint List or Library

This article explains the Rating column in a SharePoint list or library. How to enable rating in the SharePoint list or library?

Enable Rating in SharePoint List or Library

It’s very straight forward to enable rating in SharePoint lists and libraries. If you wish to utilize Ratings on a SharePoint list or library, you might think that you can do so by simply adding the “Rating (0-5)” site column to your existing list, library or content type.

In fact, SharePoint will allow you to do that, however, doing so may or may not provide the intended results. As you may already know, the proper way to enable ratings is from the list’s settings page.

Once created, open the list select “List Tools” Tab -> List Tab -> List Settings

Under General Settings click on the “Ratings settings” link.

Under the Rating Settings section select “Yes” for “Allow items in this list to be rated?”

Now a new field “Rating (0-5)” is added to the list. But the actual field name is “AverageRating”.

Add some items in the list.

When hovering the mouse over the Rating field it’ll show a message to add a rating. You can select the rating as relevant.

Knowing that the Rating feature relies on the User Profile Service, I checked in Central Admin under “Manage Services on Server” and verified that this service was running. I found an article that mentioned a specific timer job called “User ProfileService Application – Social Rating Synchronization Job” that is required for ratings to work.

So I checked my Timer Job Definitions and could not find this Timer job. While this timer job is not specifically necessary for the rating stars to turn yellow, I took this as a hint that something was not quite right with the rating feature.

This job executes every hour by default. If required it can be executed manually by “Central Administration -> Monitoring -> Timer Jobs -> Review Job Definitions -> User Profile Service Application – Social Rating Synchronization Job -> Run Now” or change the “Recurring Schedule” as required.

Once the Synchronization job has executed then users can see the average ratings (Blue Stars).

Before Synchronization Job execution:

After Synchronization Job execution:

Hover the mouse over the blue star ratings to know you’re rating (only if you have already given a rating).

You may like following SharePoint list and library tutorials:

• How to get documents from document library in SharePoint using Rest API
• Change column ordering in list forms in SharePoint Online
• How to remove/hide default title column from SharePoint Online list
• Create a Survey in SharePoint Online
• Save site as template option missing in SharePoint online
• Different ways to hide/disable quick edit in a list in SharePoint
• Change default list view style using CSS in SharePoint Online
• User Information List in SharePoint