Use AverageIf to do turnaround time?

A.J.
A.J. ✭✭✭✭✭✭
edited 05/16/23 in Formulas and Functions

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:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!