Figuring out the Average within a Week
I am currently trying to figure out how to average the turn time for our projects. In Excel all you have to do is select the number of days each project took for that week and it shows you the average. I can't seem to figure out how to do that in Smartsheet. I have a column for Week Number. The total is also based on the Status field. If the status field has a "Z" in it then it will average the projects based off of those rows. I have circled the columns that will be involved in the formula.
Hope this makes sense
Help Article Resources
Check out the Formula Handbook template!