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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!