I have a sheet with form data in several columns, say A:G. Some of the data are numerical and I'd like to have some calculations done on them, e.g. in columns H through J. I have already found out any stretched formulas get wiped out as new lines from the form get pulled in.
So I created a new sheet, imported the data using
arrayformula, but still, I don't know how to have a formula for every row in columns H:J (except the header). I can only stretch the formula within a fixed number of rows, but don't know how to make it autoadjust to newly incoming data.
I wondered if I could use a script that would be triggered with the form being submitted, adding the formulas to the new lines, but that's rather inelegant.