=AVG function


I'm trying to get an average sales total for 2020. We are only on week 7 but it counts ALL 52 and averages it out. How can I get the function to work so it only averages the current week and prior weeks?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!