CODEWITHSUNDEEP
google-sheetsspreadsheet
Alejandro Goffa
Alejandro Goffa

Reputation: 99

How do I keep a formula when a new row is added?

I set an automation that when a form is submitted, a new row is added in Google Sheets, including a First Name and a Last Name cell. I have a Contact Name field with this formula: =ArrayFormula(CONCATENATE(C9;" ";D9)).

When a new row is created, the formula is not applied to the new Contact Name cell. What I found so far is using references that don't work with CONCATENATE like (C:C; " "; D:D), and the ArrayFormula doesn't work either.

What would be the best approach here?

Upvotes: 0

Views: 954

Answers (1)

player0
player0

Reputation: 1

use this in row 1:

=ARRAYFORMULA({"header"; C2:C&" "&D2:D})

Upvotes: 1

Related Questions