1/2 star ratings in Scale column?

For the scale column, any way to make it more granular? I am less worried about users selecting individual items but more that the averages/summarization will not reflect reality (e.g: 4.4 across 100 reviews does not = 4 stars, its 4.5 stars in my head).

Thoughts? Any way to use a typed formula to get this to appear correctly on the page?


Hi Aaron,

Welcome to the community!

I am not sure I understand your problem? Is this not what you are looking for?


Hi @Piet_Strydom,

I think I understand what @Aaron_Joseph1 is saying, as I arrived here with a similar question. I have a table using the SCALE, which allows for example 1 to 5 stars. But each star is a WHOLE star, so you can only score whole values i.e. 1, 2, 3, 4 or 5.

I would like to score 3.5, and not be forced to decide whether to score a 3 or a 4.

I would also like the AVERAGE calculated to take this into consideration and continue to work as it is. I am just wanting the SCALE to be more granular if that makes sense to allow HALF stars.

Is that possible?


The simplest would be to extend your number of stars to 10.

I am not aware of another way to do this.

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.