# If Then column brings edited values

**URL:** <https://community.glideapps.com/t/if-then-column-brings-edited-values/9251>\
**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:** 1\
**Showing post:** 10

<div class="post-metadata">

**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")

</div>

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")

---

_[View the full topic](https://community.glideapps.com/t/if-then-column-brings-edited-values/9251)._