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.4K Get Help
- 396 Global Discussions
- 213 Industry Talk
- 448 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 133 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 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!