CODEWITHSUNDEEP
google-sheets
Suraj S
Suraj S

Reputation: 45

How do I add formulas to additional rows of my Google sheet automatically?

All my rows have the same formulas. I want it to be copied to the newly added rows automatically. Sheets provide us with 1000 rows initially and an another 1000 or so can be added subsequently as per requirement. I want sheets to automatically copy paste formulas to the newly added row.

Upvotes: 0

Views: 61

Answers (1)

JPV
JPV

Reputation: 27262

I couldn't edit the sheet (because of protection on the sheet) but try clearing out alll contents of column T and then enter in T1

={"SPOT SURVEYOR'S MOBILE NO"; Arrayformula(if(len(S2:S), IFERROR(vlookup(S2:S,$EE$2:$EO,5,0)),))}

and see if that works?

Upvotes: 2

Related Questions