AVG TURN TIME?

Hello! I am using the NETWORKDAYS function to calculate the number of days in the Turn Time column. I can't figure out what formula to use to find the average, excluding the cells with #Invalid Data Type. The hover pop-up at the bottom shows the correct answer (6.15) but I don't know how to get there myself!


Best Answer

  • Genevieve P.
    Genevieve P. Employee
    Answer ✓

    Hi @Matt Corder

    I agree with @BullandKhmer!

    Formulas don't like referencing columns that contain a formula error. It will see the error and then produce an error itself, even though you want it to skip those cells.

    The easiest way to fix this would be to wrap an IFERROR function around whatever formula you have in your Turn Time column, like so:

    =IFERROR(formula, "")

    So:

    =IFERROR(NETWORKDAYS(formula), "")

    Then once the entire column is clear of errors, you can Average the column with another formula:

    =AVG([Turn Time]:[Turn Time])


    Cheers,

    Genevieve

    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!