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.

How to compute Average Ratings on a Subset of Rows

Robbie Rivera
edited 12/09/19 in Archived 2017 Posts

Trying to put a formula that will compute the average rating based on organizational grouping.

I have a smartsheet that has a drop down field which includes organization functions like: engineering, IT, Sales, Marketing, ...

I have another field that is a numeric rating for these organizational functions.  1 thru 5. 

I need a report that will aggregate and display by organization and their corresponding average ratings.  Something like

Organization                    Average Rating

Engineering                     5

Sales                               4.5

IT                                     3


I know how to use Sights dashboard to display the results, but need help in putting the formula(s) together.  Thanks in advance for any help


This discussion has been closed.