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.
+18Hi @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
+8I 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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.