# Date String "Gone!"

**URL:** <https://community.glideapps.com/t/date-string-gone/1173>\
**Category:** Ask for Help\
**Created:** [October 14, 2019, 5:12pm UTC](https://community.glideapps.com/t/date-string-gone/1173 "2019-10-14T17:12:06Z")\
**Posts on this page:** 1\
**Showing post:** 9

<div class="post-metadata">

**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\
**Post date:** [October 16, 2019, 7:37pm UTC](https://community.glideapps.com/t/date-string-gone/1173/9 "2019-10-16T19:37:52Z")

</div>

I prefer putting the arrayformula in row one along with the column label/title. There is no way it can be deleted by the app and it eliminates the need of the seemingly empty row 2. There are two ways to do it. I prefer the first one listed and am in the process of changing all of my sheets to work this way.

```auto
={"Add Method 1";ARRAYFORMULA(IF(ISBLANK(A2:A),"",A2:A + B2:B + C2:C))} 

```

> [@Using ARRAYFORMULA()'s in Row 1 of your Spreadsheet](https://community.glideapps.com/t/using-arrayformula-s-in-row-1-of-your-spreadsheet/529):
>
> I can’t take credit for this tip but I just found out about this trick/tip by reading a post [here](https://community.glideapps.com/t/if-user-deletes-1st-row-he-loses-array-formula/246). So the “Normal” way of using an ARRAYFORMULA function is to use it in row 2 of a given column. You just have to be careful not to accidentally deleted it, or have a user delete it. So the next idea was to put it in row 2 but not put any other data in the row and then hide or minimize that row. Basically your data for the non ARRAYFORMULA columns would start on row 3. Then I saw the post I’ll l…

---

_[View the full topic](https://community.glideapps.com/t/date-string-gone/1173)._