I'd like to automate the calculation of a rolling average:
"Average the value of the past four weeks"
"Average the value of the past 12 weeks"
The 'SUP avg' column is what I want to average, and 'W#' is week number.
I know we can get the current week number with =WEEKNUMBER(TODAY())
though I haven't figured out the rolling average
=AVG(COLLECT([SUP avg]:[SUP avg], [W#]:[W#] = WEEKNUMBER(TODAY()) -3, [W#]:[W#] = WEEKNUMBER(TODAY()) -2))