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

Best Answers


  • That worked! Thank you so much Genevieve!

    One thing that I forgot to include is that I need to use the Revision column as well. Could I include that in the COLLECT function along with the other areas that I am searching in order to filter it down even more?

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!