How to get average per person from the form submissions?
Hi, I've created a form and workflow to notify a specific group of persons just once new form gets submitted and all that works just perfect. I am now trying to get an average per person from all the submissions to see an overall "rating" and this is what I want to email to a specific person weekly. Can anyone advise how to handle that as I am not able to get the average per person in any summary report I've tried. Thanks a lot
Best Answer
-
Hey Martin
If I understand this correctly, if you have 10 people, giving a variety of ratings, you want their overall average rating.
If that is the case, this would work.
It adds up their total ratings, then divides by the frequency their name comes up.
If I misunderstood, please add more details and I'll try to help.
=ROUND(SUMIF(NAME:NAME, "JACK", AMOUNT:AMOUNT) / COUNTIF(NAME:NAME, "JACK"), 0)
Answers
-
Hey Martin
If I understand this correctly, if you have 10 people, giving a variety of ratings, you want their overall average rating.
If that is the case, this would work.
It adds up their total ratings, then divides by the frequency their name comes up.
If I misunderstood, please add more details and I'll try to help.
=ROUND(SUMIF(NAME:NAME, "JACK", AMOUNT:AMOUNT) / COUNTIF(NAME:NAME, "JACK"), 0)
-
Hi Nick
thanks for your reply! That helped a lot :)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!