How to use a value in AVG that is selected from criteria



Would like to ask a question regarding AVG and the ability to only pick up a value if a certain condition is meet.

Here is what I'm using. =IF({Call Center_Help Desk Data Priority} = "Level 1 - Critical", AVG({Call Center_Help Desk Data Value TTFA}))

Objective: To pull in a value to be averaged for all Level 1 Critical tickets taken in, so I can report / show on a dashboard my Level 1 Critical data.

Any suggestions / recommendations would be greatly appreciated!

Thank you!


Edward Nadareski


(p): (518) 857-1221

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!