How do I calculate a Group Average for the Most Recent Date?

Welcome to the New Smartsheet Online Community


You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.

How do I calculate a Group Average for the Most Recent Date?

I have assessment scores for individuals within different groups (Male or Female). The assessments are taken over time as a sort of "pulse check." Now, I want to be able show a group average (average for all Males and average for all Females) for the most recent round of assessments. How do I calculate that?

I've tried combinations of Max, Ave, and Collect statements, but can't seem to get them to work in the right order. The picture below shows what I'm trying to accomplish.

Any guidance? Thanks in advance.

Best Answer

Answers

  • Genevieve, Thank you! I've been trying for a few days to get this to work. What I was missing was that piece of referencing the average formula back to the Max Date and the Gender column. It all works now!!! Thank you!

  • Wonderful! I'm so glad to hear it works. :)

Sign In or Register to comment.