Using AVG to Calculate Average Completion Time


Good afternoon,

I am trying to find the average of a column and am having problems using AVG, AVG COLLECT, etc.

I am trying to find the average of "Completion Time" column.

As you can see sometimes there is no data and sometimes it says "invalid data" while awaiting the completion date. I want to put an average completion time field in my sheet summary.

Can someone help me? Thanks! @Paul Newcome maybe you can help :)


Best Answer

  • Michael Culley
    Michael Culley ✭✭✭✭✭
    Answer ✓

    If you add an iferror statement to your column formula in Completion Time you can get rid of that error message.

    Add this to the front of your formula: =iferror(

    Then add this to the back: ,"")

    If you copy and paste your formula I can show you better.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!