Averages and sums in data based upon a name column

NBurrusNBurrus ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions
05/30/19 Edited 12/09/19


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:


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

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

Thank you! 

Popular Tags:


  • Paul NewcomePaul Newcome ✭✭✭✭✭

    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 NewcomePaul Newcome ✭✭✭✭✭

    Did these suggestions work for you?

Sign In or Register to comment.