Sheet summary looking to get an average time to repair for specific issues that come in. Currently I have a formula that show AVG for every issue
Trying to get a formula to show this average to add to a dashboard view
You can use an AVERAGEIF Function to Average one column based on criteria in another.
=AVERAGEIF([Criteria Column]:[Criteria Column], "Criteria", [Column to Avg]:[Column to Avg])
In your sheet, it would look something like this:
=AVERAGEIF([Issue Category]:[Issue Category], HAS(@cell, "Connectivity"), MTTR:MTTR)
I used the HAS Function because it looks like your Issue Category column is multi-select. HAS will find any cell that has that specific selection, even if it's with other values. Let me know if this works for you!
Thank you so much. The formula worked like a charm
Wonderful! I'm glad I could help. 🙂
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
©2022. All Rights Reserved Smartsheet Inc.