I have Google Sheet connected via Zapier to automatically add a new row to my spreadsheet everyone time someone fills out a satisfaction survey on my website. I have =AVERAGE(F3:F) as the top row to show running averages of numerical values.
Problem is, when Zapier adds a new row, it seems to use the "Insert 1 Above" on Row 3, thus the formula changes automatically to
=AVERAGE(F4:F) and the cell outputs #DIV/0! divide by zero error. How to avoid this?