Averages and sums in data based upon a name column
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:
- 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?
Dr. St Nicholas Burrus DHA, PMP
I build Smartsheets for the US Government, State Government, and about a dozen of the US Fortune 100s.
Help Article Resources
Check out the Formula Handbook template!