Average turnaround time based on 2 columns
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!
Best Answer
-
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"))
Answers
-
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"))
-
@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?
-
@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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!