# HELP - Protect cell to prevent updating when adding new row

**URL:** https://community.glideapps.com/t/help-protect-cell-to-prevent-updating-when-adding-new-row/2503
**Category:** Ask for Help
**Created:** [November 29, 2019, 9:14am UTC](https://community.glideapps.com/t/help-protect-cell-to-prevent-updating-when-adding-new-row/2503 "2019-11-29T09:14:53Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)
#### Post date: [November 29, 2019, 9:14am UTC](https://community.glideapps.com/t/help-protect-cell-to-prevent-updating-when-adding-new-row/2503/1 "2019-11-29T09:14:53Z")

</div>

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

---

<div class="post-metadata">

### Author: ![Karim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/karim/32/13974_2.png) [@Karim](https://community.glideapps.com/u/Karim)
#### Post date: [November 29, 2019, 9:51am UTC](https://community.glideapps.com/t/help-protect-cell-to-prevent-updating-when-adding-new-row/2503/2 "2019-11-29T09:51:14Z")

</div>

Hi,

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

---

<div class="post-metadata">

### Author: ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)
#### Post date: [November 29, 2019, 10:15am UTC](https://community.glideapps.com/t/help-protect-cell-to-prevent-updating-when-adding-new-row/2503/3 "2019-11-29T10:15:38Z")

</div>

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

---

<div class="post-metadata">

### Author: ![Karim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/karim/32/13974_2.png) [@Karim](https://community.glideapps.com/u/Karim)
#### Post date: [November 29, 2019, 1:37pm UTC](https://community.glideapps.com/t/help-protect-cell-to-prevent-updating-when-adding-new-row/2503/4 "2019-11-29T13:37:03Z")

</div>

Yes,  
I believe it should work.
