HELP - Protect cell to prevent updating when adding new row


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?



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

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

I believe it should work.