Taking Average With Grouped Values

Muhammad

Hi all!

I am very new to Smartsheet and am trying to come up with a solution regarding taking an average of matching column values. To explain in more detail, I have "Week Of" column and a "Days to Complete" column. I would like to take the average of the "Days to Complete", but only for corresponding weeks. Essentially, the input is a group of days to complete that has weeks completed assigned to them, and i want to display the week completed, followed by the average per week (calculated by adding days completed, and adding them to the amount of completions per week). I will share a screenshot of the mock data I am using to accomplish this task.

Thank you all in advance for taking time out of your schedules to help me, any advice or nudges in the right direction are greatly appreciated!

Paul Newcome

@Muhammad I believe we are working on this here:

https://community.smartsheet.com/discussion/comment/332576#Comment_332576

Paul Newcome

@Muhammad I believe we are working on this here:

https://community.smartsheet.com/discussion/comment/332576#Comment_332576