Formula for avg of 1 column to a specific issue in another column

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

Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓

    Hi @DannyApa

    You can use an AVERAGEIF Function to Average one column based on criteria in another.

    Example structure:

    =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!




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!