Average If Unpareseable
My team wants to track the average day count that that a customer request has been open based on the request type.
My formula is:
=AVERAGEIF({Support_Case Age}, {Customer Support Range 1} = "IT Request")
What I want is the Average of the {Support_Case Age} column, if the value in the {Customer Support Range 1} is "IT Request".
Looking at the function syntax AVERAGEIF( range, criterion, [ average_range ] )
I believe my range should be
{Support_Case Age}
My criterion should be
{Customer Support Range 1} = "IT Request"
If the criterion is not met I do not want the entry counted so I believe the [ average_range ] should be left blank.
Thank you in advance for any help you can provide.
Best Answer
-
Hi Joseph,
Try this:
=AVERAGEIF({Customer Support Range 1}, "IT Request", {Support_Case Age})
Let me know if it works!
Best,
Heather
Answers
-
Hi Joseph,
Try this:
=AVERAGEIF({Customer Support Range 1}, "IT Request", {Support_Case Age})
Let me know if it works!
Best,
Heather
-
This works perfectly thank you Heather!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 445 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!