Average Collect - Find Overall Class Rating in a Date Range


Hi Smartsheet Community!

I'm looking to average an overall class rating for classes that took place from January 1, 2023, to January 31, 2023. Below is the calculation I have so far, but I keep getting incorrect argument set.

Any ideas would be greatly appreciated. Thank you :)

=AVG(COLLECT({Class from Feedback Sheet}, HAS(@cell, [Column 2]@row), {Rate Class Overall}, {Date Attended Class}, AND(@cell >= DATE(2023, 1, 1), @cell <= DATE(2023, 1, 31))))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!