Taking Average With Grouped Values

Muhammad · 06/10/22

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.