I am using a google sheet as a database. When a row is populated (using JSON API and Integromat), I want formulas in the newly added row to update. However, I cannot get the formula to be applied to the whole column automatically.
For instance, C1 is =A1+B1
. When A2 and B2 are added, C2 should be =A2+B2
.
I have tried:
=A1:A+B1:B
. This formula is only applied to the selected cell.=A1:A+B1:B
.I'm sure I'm just making a stupid error, but I haven't been able to find any solutions.
Thanks in advance!
Place this in the header row (assuming the header row and you want to add all other rows).
={"YOUR HEADER";ARRAYFORMULA(A2:A+B2:B)}