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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!