Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Using formula to average columns with rating stars
See my screen shot below.
I am trying to get score cell circled in red below to look at the star rating symbols in the child rows and provide the average of the child rows in the score cell.
I am assuming that 0 stars equals 0%, 1 star equals 20% etc..........
Help pointing me in the correct direction would be great.