#Unparseable - AVG if business unit and current year.

Jason P

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")

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.

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.