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 :)

Find more posts tagged with

Formulas

Accepted answers

Michael Culley

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.

All comments

Michael Culley

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.

OFNS BCPS

Thank you so much, that solved my problem!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.