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!