Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

How to Average Rating with Stars Instead of Numbers

6434 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Reuben
6 - Interface Innovator
6 - Interface Innovator

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.

Screen Shot 2019-04-25 at 3.05.46 PM.png

2 Replies 2

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

kschnaenberg
6 - Interface Innovator
6 - Interface Innovator

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.