1
votes

I have this spreadsheet in Google:

enter image description here

I need set a ARRAYFORMULA function at "Valor" column, because the rows are autogenerated by a Google Form, and I need apply de same formula for new rows.

How can I combine filter and arrayformula?

Thanks

1

1 Answers

0
votes

According to your data:

=ARRAYFORMULA(A2:A&B2:B&C2:C)

enter image description here