Average If by Current week

Options
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.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!