How to Average Rating with Stars Instead of Numbers

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.

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

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

JB

3 Likes