I have a form submitting new rows to a Google Sheet. I am submitting =LOWER(SUBSTITUTE(E2," ","-")) as a cell formula directly into the adjacent F2.

The question is how to change E2 for E3, E4 etc as more rows are submitted through the form?

Regards Matt

CodePudding user response：

Try this :

Put this in F2

=Arrayformula(LOWER(SUBSTITUTE(E2:E," ","-")))