Average turnaround time based on 2 columns


I'm trying to calculate the average turnaround time based on the level of priority column and the average days calculated in Avg turnaround by COO.

I've tried the AVERAGEIF Function can't seem to find the right combination. Could someone help in giving me a string that for example, if it's medium priority it calculates the average turnaround for that priority?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!