# Overriding data Date & Time Selector **URL:** \ **Category:** Ask for Help\ **Created:** [May 14, 2021, 10:08am UTC](https://community.glideapps.com/t/overriding-data-date-time-selector/26789 "2021-05-14T10:08:02Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![NOBA\_Ventures](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/noba_ventures/32/14991_2.png) [@NOBA\_Ventures](https://community.glideapps.com/u/NOBA_Ventures)\ **Post date:** [May 14, 2021, 10:08am UTC](https://community.glideapps.com/t/overriding-data-date-time-selector/26789/1 "2021-05-14T10:08:02Z")
Hello! I’ve been having a weird problem with the Date & Time Selector, and I’m not sure if I’m doing something wrong or if it’s an error. I have a Date & Time selector that writes the “Input Date” Column. For some reason in some inputs, the data is also being written on another column that has its own formula. And this is making the whole logic of the sheet crash. Help(?) ![Screen Shot 2021-05-14 at 12.03.09 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/a/7a59ed157b45b94220d539de9bd92e70bb824db6.png) ---
**Author:** ![julien\_roullier](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/julien_roullier/32/2164_2.png) [@julien\_roullier](https://community.glideapps.com/u/julien_roullier)\ **Post date:** [May 14, 2021, 10:15am UTC](https://community.glideapps.com/t/overriding-data-date-time-selector/26789/2 "2021-05-14T10:15:20Z")
Delete D10 in the sheet ---
**Author:** ![NOBA\_Ventures](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/noba_ventures/32/14991_2.png) [@NOBA\_Ventures](https://community.glideapps.com/u/NOBA_Ventures)\ **Post date:** [May 14, 2021, 10:17am UTC](https://community.glideapps.com/t/overriding-data-date-time-selector/26789/3 "2021-05-14T10:17:29Z")
Deleting fixes the issue temporarily, because with a new input it will override the data on D column once again 😕 ---
**Author:** ![julien\_roullier](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/julien_roullier/32/2164_2.png) [@julien\_roullier](https://community.glideapps.com/u/julien_roullier)\ **Post date:** [May 14, 2021, 10:19am UTC](https://community.glideapps.com/t/overriding-data-date-time-selector/26789/4 "2021-05-14T10:19:18Z")
It means that in glide you set column D ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [May 14, 2021, 10:22am UTC](https://community.glideapps.com/t/overriding-data-date-time-selector/26789/5 "2021-05-14T10:22:21Z")
> [@NOBA\_Ventures](#): > > I have a Date & Time selector that writes the “Input Date” Column. For some reason in some inputs, the data is also being written on another column that has its own formula. And this is making the whole logic of the sheet crash. Unrelated to your problem, but unless you actually need those extra columns in the GSheet, I’d be doing those calculations in Glide. Arrayformulas have their uses, but as you’re finding out they are very easily broken. This problem goes away when you move the logic into the GDE (and your app runs faster). ---
**Author:** ![NOBA\_Ventures](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/noba_ventures/32/14991_2.png) [@NOBA\_Ventures](https://community.glideapps.com/u/NOBA_Ventures)\ **Post date:** [May 14, 2021, 10:23am UTC](https://community.glideapps.com/t/overriding-data-date-time-selector/26789/6 "2021-05-14T10:23:55Z")
No and that’s the problem: the set column is B ![Screen Shot 2021-05-14 at 12.23.23 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/c/5c907dd7743e23fe8a4e86f3532f4fb11637d60c.png) ---
**Author:** ![NOBA\_Ventures](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/noba_ventures/32/14991_2.png) [@NOBA\_Ventures](https://community.glideapps.com/u/NOBA_Ventures)\ **Post date:** [May 14, 2021, 10:24am UTC](https://community.glideapps.com/t/overriding-data-date-time-selector/26789/7 "2021-05-14T10:24:40Z")
I’ll try to move it and see if I can work my way around it… but the overriding data is very intriguing 😕 ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [May 14, 2021, 10:27am UTC](https://community.glideapps.com/t/overriding-data-date-time-selector/26789/8 "2021-05-14T10:27:28Z")
Just a guess, but it could be that Glide is writing a blank value to that column, which breaks the arrayformula. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [May 14, 2021, 1:06pm UTC](https://community.glideapps.com/t/overriding-data-date-time-selector/26789/9 "2021-05-14T13:06:05Z")
I think I faced this problem months ago. I was writing something to a specific column but then decided not to do it anymore and used an arrayformula. Glide did not reset that to “nothing”, but a blank value as you suggested. Had to recreate the action. ---
**Author:** ![NOBA\_Ventures](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/noba_ventures/32/14991_2.png) [@NOBA\_Ventures](https://community.glideapps.com/u/NOBA_Ventures)\ **Post date:** [May 18, 2021, 4:47pm UTC](https://community.glideapps.com/t/overriding-data-date-time-selector/26789/10 "2021-05-18T16:47:33Z")
I replicated the action using Glide functions, and I think that worked. But it’s a real bummer