Google Sheets is a highly praised product from the house of Google. The fact that it is available for free is the best thing. If are used to using Google Sheets, you know the kind of features and interface it has.
Google Sheets is more than what you think. It has certain features that make it stand out from other similar programs. For instance, it is possible to create a star rating system in Google Sheets. If you are wondering how we are here to help.
It is quick and easy to add a rating system to your Google Sheets. This is done using the CHAR and REPT functions. But we will be discussing that in detail. In this post, we will provide the steps to add a star rating system in Sheets. Make sure you follow all the steps correctly and you are good to go.
Steps to create a star rating system in Google Sheets:
- Create a table showing a list of movies and their ratings:
Here the score of the movie is given and according to that score we will create the star ratings using In column C, we will transform that value into a more visually appealing star rating.
The star is created with the CHAR function, which returns a character based on a Unicode number.You use the REPT function to repeat the star corresponding to the rating value.
- In the C2 column we will insert the following formula
=REPT(CHAR(9733),B2)- You will see the star appear on the Rating column:
- Now, just drag the cell to apply to the rest of the cells:
