Taking Average With Grouped Values

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!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!