Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
=AVGIFS Function Workaround
So there isn't an AVGIFS function currently in SmartSheet, but I still need to find a workaround. I came up with:
=IF(AND([Project Manager]="Name",[Owner]="Name",[Project Status]="Complete"),AVG([Days to Complete]),"")
However I am coming up with a "MISSING OR INVALID PARAMETERS error. I have pulled the averaging portion out and it works fine on its own.
Any ideas?
Comments
-
Todd,
You are missing references to the row. The error message can be misleading (at least to me) when this is the case.
I'm not sure that is going to work.
Let us know if it did (or didn't).
I have some ideas but it is time for sleep.
Craig -
Quickly looking at your formula I see a couple errors.
First, [Project Manager], [Owner], are not cell references - they are just the name of a column with brackets.
This is a cell reference:
[Project Manager]2
or
Owner2
If you want reference a range of cells...
[Project Manager]2:[Project Manager]10
or
Owner2:Owner10
If you want to reference an entire column:
[Project Manager]:[Project Manager]
or
Owner:Owner
You are correct in that there is not an AVGIFS but you can just use COUNTIFS and SUMIFS to get the same results
SUMIFS / COUNTIFS = AVGIFS
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives