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

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.
Answers

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.

Thank you so much, that solved my problem!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.8K Get Help
 409 Global Discussions
 219 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!