Averageif and match for summary of info

SarahML ✭✭✭✭
edited 09/02/21 in Formulas and Functions

I'm trying to average the the percent of submissions for an assignment on one Smartsheet based on a teachers ID in the current sheet. Here's the formula I've tried

=AVERAGEIF({Quiz 1 Completion Avg}, MATCH(ID@row, {ID }))

The results that are populating in my sheet do not match with are not correct.

We have one sheet (the Tracker Sheet) that has all the information by teacher by section and I'm trying to get a summary to show in our Teacher Summary Sheet for the course. I've looked at avg(collect( and AverageIf. There are more rows in the Tracker Sheet than the Teacher Summary Sheet.



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!