If Then column brings edited values

[Jeff_Hager]

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

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