#INCORRECT ARGUMENT SET in an AVG(COLLECT)

Options

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!