Not sure what formula to use to get 1 description name with the average MM per Piece

Pamela.Baron

I have a sheet with a column named Description and another column named MM per Piece. There are multiple items in the Description column and I need to obtain the average MM per Piece based on the entries for each item.

Any assistance is appreciated.

Pamela.Baron

SteyJ

Hello @Pamela.Baron,

for MM average, can do it two ways. I recommend using sheet summary field and inputting the formula:

=AVG([MM per Piece]:[MM per Piece])

alternatively, you can create a report and and use Summary the average of the column

Hope this helps!

Pamela.Baron

I am hoping for something like

Description MM per Piece

Black Diamond Arm Chair 0.70814

Black Diamond Side Chair 0.93382

etc, The first option you suggested provides the overall average for all pieces which is not what I am wanting. The second item I can't get the Description to show up in line with the averages. I get

SteyJ

https://community.smartsheet.com/discussion/comment/390132#Comment_390132

Hello @Pamela.Baron,

What do you mean when you say you need the description to show in line with the averages?

Sorry for the misunderstanding

Pamela.Baron

Between the TSS # and the MM per Piece

Pamela.Baron