0

I have a form that is submitted to the spreadsheet.

In that spreadsheet I've added a second sheet Results where I want to organize processed view of results. But when the form is submitted, the new row is inserted into the Ответы на форму (1) sheet. The problem is that such rows are not handled on the Results sheet.

So how can I handle form submits if I want processed rows to appear automatically?

Filling diagram

PS: Feel free to clone Results sheet for your experiments.
You can edit the document except of 2 sheets (Ответы на форму (1) and Results).

1

Use arrayformula syntax for such operations. Simple copying from one sheet to another:

=arrayformula(Source!C:C)

Processing all E column (starting with 2nd row), marking + if the content of D1 is found:

=arrayformula(if(isnumber(find(D1, E2:E)), "+", ""))

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.