# Average turnaround time based on 2 columns

Options

Hi,

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?

Thanks!

• ✭✭✭✭✭✭
Options

Try this one...

=AVG(COLLECT([Average Turnaround Time For COO Review]:[Average Turn Around Time For COO Review], [Level of Priority]:[Level of Priority], "Medium"))

• ✭✭✭✭✭✭
Options

Try this one...

=AVG(COLLECT([Average Turnaround Time For COO Review]:[Average Turn Around Time For COO Review], [Level of Priority]:[Level of Priority], "Medium"))

• Options

@Paul Newcome Hi Paul! I'm looking to calculate the average turnaround based on a date. So looking to recalculate for 2022 the formula above is perfect just need it for specific dates. Any formula modification for that?

• ✭✭✭✭✭✭
Options

@Natalia Pagano Do you mean for any entries where the date is in the year 2022?

=AVG(COLLECT([Average Turnaround Time For COO Review]:[Average Turn Around Time For COO Review], [Level of Priority]:[Level of Priority], "Medium", [Date Column]:[Date Column], IFERROR(YEAR(@cell), 0) = 2022))

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!