# If Then column brings edited values **URL:** \ **Category:** Report a Bug\ **Created:** [May 16, 2020, 5:14pm UTC](https://community.glideapps.com/t/if-then-column-brings-edited-values/9251 "2020-05-16T17:14:47Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [May 16, 2020, 5:14pm UTC](https://community.glideapps.com/t/if-then-column-brings-edited-values/9251/1 "2020-05-16T17:14:47Z")
I’d really like to when If Then column brings me the value edited as we already did in Data, and not like this 👇 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/8/89003eb0e0efadd60c90c644bda3489be338d70a.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/d/d2318eccba1c5f2ef69449be720198943a576991.png) Cause my intention is to display it in a Tiles Details but… ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/8/89d691562bf77b719b10a2d1c526e52a99b0b840.png) ---
**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:** [May 16, 2020, 5:20pm UTC](https://community.glideapps.com/t/if-then-column-brings-edited-values/9251/2 "2020-05-16T17:20:11Z")
Related to this. > [@In-app filter with dates shows dates in ugly format](https://community.glideapps.com/t/in-app-filter-with-dates-shows-dates-in-ugly-format/8818): > > Hello everyone, I have an app where I use in-app filter with dates, but it shows dates in a very ugly way. In data builder I have configures how to visualize dates, but it seems to me that this does not affect to in-app filter… Is there a way to change that? Thank you! ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [May 16, 2020, 5:22pm UTC](https://community.glideapps.com/t/if-then-column-brings-edited-values/9251/3 "2020-05-16T17:22:46Z")
So, is it a bug yet? ---
**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:** [May 16, 2020, 5:25pm UTC](https://community.glideapps.com/t/if-then-column-brings-edited-values/9251/4 "2020-05-16T17:25:07Z")
I don’t know. Haven’t seen anything saying it’s fixed. Might be a new bug. ---
**Author:** ![Paco\_Nunez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paco_nunez/32/6852_2.png) [@Paco\_Nunez](https://community.glideapps.com/u/Paco_Nunez)\ **Post date:** [May 16, 2020, 7:55pm UTC](https://community.glideapps.com/t/if-then-column-brings-edited-values/9251/5 "2020-05-16T19:55:01Z")
A week ago, I received official confirmation - yes, it’s a bug ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [May 16, 2020, 8:16pm UTC](https://community.glideapps.com/t/if-then-column-brings-edited-values/9251/6 "2020-05-16T20:16:29Z")
Yeah @Mark any update? ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [May 16, 2020, 8:30pm UTC](https://community.glideapps.com/t/if-then-column-brings-edited-values/9251/7 "2020-05-16T20:30:51Z")
Doing my own To-do app 😄 ![WhatsApp Image 2020-05-16 at 17.24.09](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/b/b6a8963830b1cb0b593acfde0738aa1928142fd8.jpeg) ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [May 16, 2020, 9:00pm UTC](https://community.glideapps.com/t/if-then-column-brings-edited-values/9251/8 "2020-05-16T21:00:34Z")
Hi, Did you try to fix it via Google sheet?? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/1/1e3c2ce77ab6682a37af7462c29a758b83e4cea9.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/b/ba03ef7e32c2d0b6997d9ceb6e5c4be0a47acdb3.png) I saw it days ago but I modified the column format as workaround and worked for me. Saludos Lucas ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [May 16, 2020, 10:47pm UTC](https://community.glideapps.com/t/if-then-column-brings-edited-values/9251/9 "2020-05-16T22:47:03Z")
I can’t @gvalero, ‘cause, as @Jeff_Hager mentioned here up, it’s a bug. In the sheets, the value isn’t a “date” format, it’s an ugly one with time zone and so… that’s why formatting doesn’t work > [@In-app filter with dates shows dates in ugly format](https://community.glideapps.com/t/in-app-filter-with-dates-shows-dates-in-ugly-format/8818): > > Hello everyone, I have an app where I use in-app filter with dates, but it shows dates in a very ugly way. In data builder I have configures how to visualize dates, but it seems to me that this does not affect to in-app filter… Is there a way to change that? Thank you! ---
**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:** [May 17, 2020, 12:41am UTC](https://community.glideapps.com/t/if-then-column-brings-edited-values/9251/10 "2020-05-17T00:41:41Z")
The date should be recognized by google as a date. You can try setting the column formatting in the spreadsheet. If for some reason google sheets doesn’t see it as a date (such is the case in app: logins) then you can use a formula to rebuild it as a date in a new column. > [@Date formatting](https://community.glideapps.com/t/date-formatting/2612/2): > > I don’t think Glide is saving it as a true date value. It’s appears to just be text. Try this formula. It strips out the T and Z, then converts it to a date value which can be reformatted using TEXT: =TEXT(DATEVALUE(MID(A2:A,1,10)) + TIMEVALUE(MID(A2:A,12,8)), "DD/MM/YYYY") ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [May 17, 2020, 1:36am UTC](https://community.glideapps.com/t/if-then-column-brings-edited-values/9251/11 "2020-05-17T01:36:27Z")
Sorry, we’ll fix this in due time. ---
**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:** [February 8, 2024, 5:39pm UTC](https://community.glideapps.com/t/if-then-column-brings-edited-values/9251/12 "2024-02-08T17:39:09Z")