# Use AverageIf to do turnaround time?

Options
✭✭✭✭✭✭
edited 05/16/23

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?

Tags:

• ✭✭✭✭✭✭
Options

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

• ✭✭✭✭✭✭
Options

Hi @Paul McGuinness, thanks for the response!

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

• ✭✭✭✭✭✭
Options

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

• ✭✭✭✭✭✭
Options

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

• ✭✭✭✭✭✭
Options

Hi @A.J.

Glad it worked in the end.

Thanks

Paul

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!