I have a sheet with form response 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
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.
Sheet1 contains form data,
Sheet2 imports them using arrayformula.