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

[kschnaenberg]

I know old post but I came up with an alternate approach that worked.  

1) Create an average field of the ratings you want to combine, will provide an intergern.  Round to 0 decimals. 
2) Create a second field with rating type, leave blank.
3) Create an automation to update the field in step 2 whenever the field from 1 is updated.  Have it enter the amount from field 1.  This creates what is being asked for.