Average If by Current week

Larissa Teoh
Larissa Teoh ✭✭
edited 05/10/21 in Formulas and Functions

I'm trying to figure out the formula to calculate the average of a column based on the current week.

I do have a week column.

I tried this but it didn't work :(

=AVERAGEIF([Created Week]:[Created Week],TODAY,[Overall Satisfaction]:[Overall Satisfaction])

And then... I'm also looking for the average for the PREVIOUS week.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!