AVG formula and Invalid Data Error

Hello,

I seem to have hit a bit of a pickle (or an afternoon brain fart) while trying to create a roll up.

Essentially what I'm trying to do is create a roll up of averages by month and my formula is returning an Invalid Data Error. I checked the reference columns and they are indeed date columns but beyond that, it should be pretty straight forward:

=AVG(COLLECT({Assigned People}, {Target Date}, MONTH(@cell) = Month@row))

Is there something glaringly obvious that I'm missing?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!