#INCORRECT ARGUMENT SET in an AVG(COLLECT)
I'm using this in a cell to average values in another sheet.
=AVG(COLLECT({Assessments 2020-04-21 Range 4}, {Assessments 2020-04-21 Range 1}, "Company", {Assessments 2020-04-21 Range 3}, "Scheduled"))
just trying to average a column of numbers in Range 4 only if matches a Company in Range 1 and a Status in Range 3. I have seen it shown in examples as ="Scheduled" for criteria as well and have tried it both ways. I know I am missing something simple, but I have no idea what it is.
Thank you to everyone who even takes a minute out to read the post.
Best Answers
-
It looks like your syntax is correct. Can you show a screenshot of the formula actually in the sheet similar to how I am showing a formula in the below screenshot?
-
That happens to me sometimes as well. I'll put together a formula and get an error even though there is nothing wrong with it. I'll go ahead and save, close out, then come back in, and it will be working as it should.
Answers
-
It looks like your syntax is correct. Can you show a screenshot of the formula actually in the sheet similar to how I am showing a formula in the below screenshot?
-
Thanks for the reply, Paul.
In typical fashion, when I went to open the Smartsheet to get the screenshot for you, of course the fields populated. LOL. So now I have no idea what the original problem was. The only think I can think of is maybe the files all had to be closed and saved?? Although it makes no sense as things should be able to update as you are working on them live. I don't know. Thanks again, though.
-
That happens to me sometimes as well. I'll put together a formula and get an error even though there is nothing wrong with it. I'll go ahead and save, close out, then come back in, and it will be working as it should.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!