Calculating Average Time for each member of a team

Hi everyone,

I am new to SmartSheets and Excel formulas in general and would like some help please. I would like to calculate the average time in months that it takes for a team member to complete tasks. For example, I have a date created column for every task and another column named "Team member". I would like to calculate the number of months since the task was created from today and obtain that number for every task for that corresponding team member and calculate the overall average for all of the tasks in months for every team member.

I currently have " =(NETDAYS(({Reference}, {Reference})/ 365) * 12 " to calculate the number of months for a specific cell, but I would like to do it for all the tasks corresponding to a specific team member.


Any help is greatly appreciated.

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!