# Date String "Gone!" **URL:** \ **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:** 9\ **Page:** 1
**Author:** ![imorris](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/imorris/32/408_2.png) [@imorris](https://community.glideapps.com/u/imorris)\ **Post date:** [October 14, 2019, 5:12pm UTC](https://community.glideapps.com/t/date-string-gone/1173/1 "2019-10-14T17:12:06Z")
OK… I haven’t checked one of my client apps all weekend. Just pulled up Google sheet to add new data and the “date string” is now all blank which means my customers went how long over the weekend without a follow-up date? . How can this happen? I cannot risk losing clients if this isn’t controlled. ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [October 14, 2019, 5:15pm UTC](https://community.glideapps.com/t/date-string-gone/1173/2 "2019-10-14T17:15:20Z")
Can you reproduce the problem? Does adding a new row not record the date? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [October 14, 2019, 5:25pm UTC](https://community.glideapps.com/t/date-string-gone/1173/3 "2019-10-14T17:25:51Z")
OK, 2 things. First, are you still using the formula to populate the Date String like this? ![Capture](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/1X/f0876ca29d1c462736472ace80e57a3ed9065227.jpeg) Second, was the first record deleted at some point, which would have removed the formula? ---
**Author:** ![imorris](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/imorris/32/408_2.png) [@imorris](https://community.glideapps.com/u/imorris)\ **Post date:** [October 14, 2019, 5:53pm UTC](https://community.glideapps.com/t/date-string-gone/1173/4 "2019-10-14T17:53:09Z")
Fixed… had to re-input formula in column @Jeff_Hager. How could something like that happen so I know what to look for? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [October 14, 2019, 5:58pm UTC](https://community.glideapps.com/t/date-string-gone/1173/5 "2019-10-14T17:58:28Z")
That’s why I ask if the first record was deleted. This probably removed the formula when the record was deleted. This is why I always have two header rows in my sheets. Row 1 is used for Column Heading Name, and Row 2 is used for formulas. What you need to do is insert an empty row right below the headings, then re-add the formula to cell F2 of the new empty row. You may get an error because you still have the formula you already re-added and is now in cell F3. Just clear out that cell and it will repopulate the Date String all the way down. It’s also possible that you still have Date String as an editable field in your app. If its still there, you need to make sure to remove it. ![Capture](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/1X/ce27a6c567701e2ba12d1428c77ae1353eeba405.jpeg) ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [October 14, 2019, 8:14pm UTC](https://community.glideapps.com/t/date-string-gone/1173/6 "2019-10-14T20:14:11Z")
This is why we are adding formula columns to the Data Editor. ---
**Author:** ![yinon\_raviv](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yinon_raviv/32/1627_2.png) [@yinon\_raviv](https://community.glideapps.com/u/yinon_raviv)\ **Post date:** [October 15, 2019, 4:12pm UTC](https://community.glideapps.com/t/date-string-gone/1173/7 "2019-10-15T16:12:21Z")
Really? When? ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [October 16, 2019, 3:33am UTC](https://community.glideapps.com/t/date-string-gone/1173/8 "2019-10-16T03:33:51Z")
As soon as we can, and we’ve already started. See `Template`. ---
**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")
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…