Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Apr 25, 2019 12:10 PM
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.
Apr 25, 2019 02:42 PM
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
May 10, 2024 03:52 PM
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.