Average of a sheet summary field across two sheets


I have an average calculating in Sheet A. Another average calculating in Sheet B. These averages are calculated in the Sheet Summary currently. I'd like to create an average of these two averages to appear on a dashboard. I don't believe I can do calculations in a report document. I can have this calculation done in either Sheet A or Sheet B. It doesn't really matter. Or is it better to create a third Sheet just for this calculation? I'm lost on how to reference another sheet in the formula.

=Average(Average from Sheet A + Average from Sheet B)

Result needs to be able to be populated on a dashboard.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!