average formula is not working to calculate total retention and total turnover
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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.8K Get Help
 410 Global Discussions
 219 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 142 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!