I have a Zap running on Zapier that is adding a new row/value to a Google Sheet every hour. I then want to automatically calculate the increase in value between the new row and the previous row. At the moment I have to keep dragging down the formula as new rows are added. Is there a way I can automate this process?
If I've understood your question properly you want the same formula (relative to the cells to its left) but have it where you don't have to add the formula every hour?
Can you not just drag down the formula (using the bottom right of the cell) a couple hundred cells? The formula will stay there and replicate the cells relative).
Edit: You can click on the cell which currently has the formula (in your case cell J3). ctrl + C to copy this. Click on the letter J (to highlight the whole column) Ctrl + V to paste - this will then paste the formula to the whole column indefinitely.
