How to Average Rating with Stars Instead of Numbers

[Reuben]

Hi, I have a formula that averages 2 ratings fields. I wish the formula field would show stars instead of numbers. Is there a way to do this with the rating field? Or with a more complex formula? See my current screenshot below.

[JonathanBowen]

Hi @Reuben - have a look at this post, which is a workaround for turning an integer into a star:

Convert a number into a Rating Integrations

Hi @DanielAssayag - I don’t think you can do this directly. The Rating field type does not have any inputs or dependencies and so is completely standalone and cannot be based on another field. (Aside - when you convert a rating field to a number field, the data conversion works, i.e. a 5-star rating converts to integer 5, so presumably, Airtable is storing this as a number and displaying as a star). Workaround for this is to use the REPT formula: REPT(“:star:”, {Numerical Rating}) Using an em…

You’d probably also want to do a ROUND() on the average formula to make sure you get an integer number of stars.

JB