AVG(COLLECT

Jason P

Hi @Paul Newcome

Seeking your assistance please with the below which results in #unparseable. I'm looking for the average number of days on all rows between a Created Date column (Date submitted) and a date column (date you need result back?) and the assigned person.

I've tried and failed with a number of other formulas but of all I think this is on the right track but I'm not getting it. ie

=NETWORKDAYS(DATEONLY(AVG(collect(([Date Submitted]@row,-[Date you need result back?]@row, [Assigned To]:[Assigned To],"Travis")))

Regards

Paul Newcome

You would need to calculate the number of days on each row individually first. Then you would use the AVG/COLLECT.

Jason P

Thanks @Paul Newcome

Was able to use =NETWORKDAYS(DATEONLY([Date Submitted]@row), [Date you need result back?]@row) in a new column "Turn around time" then, =AVG(COLLECT([Turn around time]:[Turn around time], [Assigned To]:[Assigned To], "Travis")) in a sheet summary field.

Cheers.

Paul Newcome

Happy to help. 👍️