#INCORRECT ARGUMENT SET in an AVG(COLLECT)

Jun Huang

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.

Paul Newcome

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?

Paul Newcome

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.

Paul Newcome

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?

Jun Huang

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.

Paul Newcome

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.