Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

How to Average Rating with Stars Instead of Numbers

5825 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.