Average Collect Unparseable Error

I'm getting an Unparseable error with my average(collect) formula and can't figure out what's wrong with it.

=average(Collect({Days to Approval}, {Level}, CONTAINS("Level 1", @cell ), {Date of Notification}, >=[Start Date]@row , {Date of Notification}, <=[End Date]@row ))

All the references within "{}" brackets are columns within another sheet.

Find more posts tagged with

Accepted answers

All comments

heyjay

Try AVG instead of AVERAGE.

=AVG(COLLECT(
{Days to Approval}, 
{Level}, CONTAINS("Level 1", @cell  ), 
{Date of Notification}, >=[Start Date]@row  , 
{Date of Notification}, <=[End Date]@row  ))

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