#Unparseable - AVG if business unit and current year.
![Jason P](https://us.v-cdn.net/6031209/uploads/userpics/RTZ9BTCJF9QF/nE7GDQAYOGAPS.jpg)
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")
Cheers.
Best Answers
-
There is no AVERAGEIFS function in Smartsheet. You would need to use an AVG/COLLECT combo.
-
@Jason P Happy to help. 👍️
The typical reason for the AND is to include a MONTH argument.
Answers
-
There is no AVERAGEIFS function in Smartsheet. You would need to use an AVG/COLLECT combo.
-
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())))
Cheers.
-
@Jason P Happy to help. 👍️
The typical reason for the AND is to include a MONTH argument.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 351 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 443 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!