average formula is not working to calculate total retention and total turnover
Options
First row is retention rate and second row is turnover and it keeps giving me an error. Below is the formula i am using for average
this is the formula i used to get turnover percentage:
But every time I put the average I get an error. Can somebody please help.
Tags:
Best Answer

Try Using AVG instead of AVERAGE as the formula name.
=AVG([January 2023]@rpw:[October 2023]@row)
Answers
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!