Are you tired of using complicated methods to add ratings to your Google Sheets? Well, worry no more because Google Sheets now offers a new built-in rating feature that will make your life so much easier! Say goodbye to using the CHAR method or star images – this new feature is more convenient and dynamic.
Google Sheets’ New Rating Feature Makes Star Rating a Breeze
So, what exactly is this new rating feature in Google Sheets? It’s called a smart chip, and it’s a game-changer. Smart chips are interactive elements that you can embed within cells in your spreadsheets. They allow you to include contextual information like ratings, files, locations, and more. These smart chips are particularly helpful in collaborative documents where multiple people are working on the same spreadsheet.
Now, with the new rating smart chip, you can easily include ratings in your spreadsheet cells. There are two ways to access this feature:
- Using the @-menu: Simply type “@” in a cell, and a menu will appear.
- By clicking ‘Insert’ > ‘Smart chips’ > ‘Rating’.
Various Ways to Utilize the New Built-in Rating Feature in Google Sheets
The new rating feature in Google Sheets is incredibly versatile, allowing you to use it in various ways. Let’s explore some of them:
Conventional Way: Scores in One Column and Star Ratings in Another Column
In the conventional approach, you may have scores in one column and ratings in another column. For example, you have scores such as 4, 2, 2, 1, 3, and 5 in cells A2 to A7. To apply the rating to these scores, simply type “@” in cell B2, scroll down, and click on “Rating.” Then, enter the formula “=A2” in cell B2 and press Enter. You can copy and paste the star rating from cell B2 to the cells in the range B3 to B7 or drag the fill handle down in cell B2. The best part is that the ratings will update automatically when you modify the scores.
Format the Numbers to Star Rating
If you want to implement a star rating quickly, this is the easiest way to do it. Select the scores in cells A2 to A7, click on “Insert” > “Smart chips” > “Rating.”
Star Rating for Multiple People Working on the Spreadsheet
This is where the new rating feature truly shines. Let’s say you want to collect user feedback for an item in cell A2. Ask users to leave their ratings in cells B2 to E2. By typing “@” and selecting “Rating” in cells B2 to E2, you can insert 0 rating stars. When a user clicks on the rating, a pop-up will appear with different rating options, or they can directly enter their score from 0 to 5, which will be converted to a star rating.
Other Advantages of Using the New Built-In Rating Feature in Google Sheets
The new built-in rating feature has some additional advantages compared to the conventional star rating system in Google Sheets. Here are two of them:
- Highlighting: Since the feature maintains a numeric underlying value, you can utilize it for conditional formatting. For example, you can adjust the rating color to green if it exceeds a particular value and to red if it falls below that value.
- Calculating Average Ratings: You can easily calculate the average rating from multiple-star ratings within a specified range. Use the AVERAGE formula to get the average of the ratings.
To implement highlighting, you can create two conditional formatting rules for the apply-to range B2:E2. The first rule will highlight the star rating in green if it’s greater than 3, and the second rule will highlight it in red if it’s less than 4. These rules will visually represent the ratings based on the specified conditions.
So, there you have it! The new built-in rating feature in Google Sheets is a game-changer, making it easier than ever to add ratings to your spreadsheets. Say goodbye to the old methods and embrace the convenience and versatility of this new feature. Check out Crawlan.com to learn more about Google Sheets and other exciting features. Happy rating!
