The Rating data type is for assigning a ranking in a cell. Rating data types offer you multiple styles (like stars, thumbs up, and hearts) and a max range between 1 and 10.
Use the Rating data type to grade candidates in your candidate tracking spreadsheet , to judge mockups of your app in development , or visually indicate how expensive products will be rated in your retail management spreadsheet . In some cases, the Icon set data type may be an alternative to Ratings, with options for RYG colored balls, Harvey balls, slate arrows at different rotations, pain scale faces, and more.
Like other data types, the Rating data type can have Strict enabled. Selecting the Strict checkbox for Rating cells will restrict users to input only ratings. Also, columns that have Strict enabled cannot have cells of different data types.
Currently, Spreadsheet.com has five rating styles—stars, hearts, US Dollar symbols, figures, or thumbs up—as shown in the image below.
When you select one of these styles, you will be able to fill the row with the desired number of symbols of that style, for instance, four out of five:
You can customize ratings to allow between 1 and 10 symbols. Empty cells naturally display zero.
If you have a large max and have trouble telling which number you're on, mousing over the different symbols will reveal mouseover text. Like in the example below:
Ratings retain their number even if you change the Max value. So, for instance, if you decrease the Max from 5 to 3, then all cells with 3, 4, or 5 will convert to 3. But increasing the Max back to 5 will cause them to resume their previous rating. Likewise, increasing the Max beyond 5 will not cause a lower rating to change.
Converting from a number to the Rating data type
If you have numbers in existing cells, Spreadsheet.com will convert the data in these cells to ratings for you. Simply change the data type of the cell, column, or range of cells to the Rating data type. For instance, converting from
to cells with ratings
The Icon set data type is similar to the Rating data type, in that it's a way to visualize data in cells. However, Icon sets also include Harvey balls, Red/Yellow/Green indicators, arrows, smileys, and more.