Averages and sums in data based upon a name column

Nick Burrus · 05/30/19

Hello,

I have a Smartsheet here with some data formatted by Name, Date, Number Done, and Hours. This data is populated by forms. Here's a live Smartsheet example:

https://app.smartsheet.com/b/publish?EQBCT=e6247aff028844ff9da1e4d0906860c2

Does anyone have any ideas how I can get the following:

Total Sum of [Number Done] by Dopey for example across all columns
Total Average [Hours] spent spent to finish exactly 1 [Number Done]
Daily Average of [Number Done]
How can I limit the Total Sum of [Number Done] by Dopey for the last 30 days?

Thank you!

Paul Newcome · 06/03/19

1. =SUMIFS([Number Done]:[Number Done], Name:Name, "Dopey")

2. =AVG(COLLECT(average:average, Name:Name, "Dopey"))

3. =AVG(COLLECT([Number Done]:[Number Done], Name:Name, "Dopey"))

4. =SUMIFS([Number Done]:[Number Done], Name:Name, "Dopey", Date:Date, @cell >= TODAY(-30))

Paul Newcome · 06/06/19

Did these suggestions work for you?

Averages and sums in data based upon a name column

Comments

Help Article Resources

Categories