#Unparseable - AVG if business unit and current year.

Hi all.

In a sheet summary field I'm looking to get the average number of days, if the year is current and for a particular business unit. Iterations on the following result in #Unparseable of #Incorrect Argument? where am I going wrong?

=AVERAGEIFS([Time in application (Days)]:[Time in application (Days)], [Date BPR]:[Date BPR], IFERROR(YEAR(@cell ), 0) = 2024, [Dept.]:[Dept.], "NMGS")

Find more posts tagged with

Accepted answers

Paul Newcome

There is no AVERAGEIFS function in Smartsheet. You would need to use an AVG/COLLECT combo.

Paul Newcome

@Jason P Happy to help. 👍️

The typical reason for the AND is to include a MONTH argument.

All comments

Paul Newcome

There is no AVERAGEIFS function in Smartsheet. You would need to use an AVG/COLLECT combo.

Jason P

Thanks Paul,

The following got the result & changed YEAR to current, also added a previous tip from your good self with IFERROR.

I noticed If I add AND to (IFERROR there is no difference, is there a reason some formulas have the AND and others do not?

=AVG(COLLECT([Time in application Days]:[Time in application Days], [Dept.]:[Dept.], "DEX", [Date BPR]:[Date BPR], IFERROR(YEAR(@cell), 0) = YEAR(TODAY())))

Paul Newcome

@Jason P Happy to help. 👍️

The typical reason for the AND is to include a MONTH argument.

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.