Multiple Sheets for Average


I am trying to put together a master metric sheet. Within this sheet, I need to pull the averages from two separate sheets into one. We currently have a flow that when it is completed on one sheet, it will automatically populate to an "archive sheet". Both of these sheets need to be captured in the average calculation.

I am able to get it from the one sheet using AVG and COLLECT, but wasn't sure if there is a way to average another range.

Any guidance would be appreciated!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!