Use AverageIf to do turnaround time?

A.J.

Hi, and thanks in advance for reading/helping. We're wanting to display up-to-the-minute turnaround times year-to-date for responses to entries. Some of the rows go back into 2022 and should not be shown as part of our metric. I am trying to use a sheet summary field to show the current average of response.

I have the following columns (that are pertinent here):

HELPER: Assigned and Prior Metric - this one is the number of days it took to respond

HELPER: Date for Initial Prioritization and Assign - this is the date the work was completed

I was thinking that I could use AVERAGEIF but I can't seem to get it to work. This is the current entry that returns UNPARSEABLE:

=AVERAGEIF([HELPER: Date for Initial Prioritization and Assign]:[HELPER: Date for Initial Prioritization and Assign], >12 / 31 / 2022, [HELPER: Assigned and Prior Metric]:[HELPER: Assigned and Prior Metric])

Can anybody help?

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul McGuinness

Hi @A.J.

You had the answer just needed to format the date into a readable metric for the formula.

=AVERAGEIF([HELPER: Date for Initial Prioritization and Assign]:[HELPER: Date for Initial Prioritization and Assign], >DATE(12,31,2022), [HELPER: Assigned and Prior Metric]:[HELPER: Assigned and Prior Metric])

Hope that helps

Thanks

Paul

A.J.

Hi @Paul McGuinness, thanks for the response!

I entered your suggestion. It is now returning INVALID VALUE. Any idea?

Paul McGuinness

H @A.J.

Can you share a screenshot of the column headers and a row of info if possible.

Does the date column only contain dates and the days column only contain numbers.

Thanks

Paul

A.J.

Hi @Paul McGuinness!

I figured it out. The date syntax above was backwards. Year goes first! That did the trick!

Paul McGuinness

Hi @A.J.

Glad it worked in the end.

Thanks

Paul

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.