AVG(COLLECT

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

Find more posts tagged with

Accepted answers

All comments

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. 👍️

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.