HELP - Protect cell to prevent updating when adding new row

Ask for Help
1

Hi

Using zapier to import data into a sheet (adding a new row)

One of the columns has a calculated field.

When a new row is added it deletes the formula in the calculated field and in effect breaks the app.

Does anyone know how to import a row but preserve the calculated field?

Thanks

2

Hi,

Are you using =ARRAYFORMULA() or is the formula in the cell (that ends up being over written)?

3

Not using array, formula in cell. Looks like array is the answer?

4

Yes,
I believe it should work.