Average of Column
Hello! I was wondering if anyone knew of a way to get an average of a column. I know we can get an average of a specific range in a column, however this sheet I'm working on is a survey and there will be ongoing entries. If possible I just want to get the average of the whole column so I don't have to come back and update.
Thank You☺️
Answers
-
Hi @Kiley Murray , You can try =AVG(Column name:Column name).
I hope it helps you.
Please accept and upvote the answer so that it can benefit users in our Smartsheet community.
Thanks & Regards
Email ID: info@sspmconsultants.com
Did I answer to your question or fix the problem? Please
help
theSmartsheet Community
by voting it Insightful/Vote Up/Awesome, or/and Accepted Answer. It will make it easy for others to discover a solution or help in answering! -
Thank you Khasim! That worked by doing. I had to type it out, instead of just selecting the column.
=AVG([Primary Column]:[Primary Column])
-
This still isn't fixed. Please address the issue of trying to average a column and needing to manually type in the formula - the user should be able to just click on any range to get the average, not have to type in manually.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!