Data written to spreadsheet from app as Text format not Time format

Ah, got it. It is a date type column, but the grid makes it appears as a text column. Not sure if that’s a bug, or because one of the dates is actually a text string.

I guess in my case, I don’t do anything special in the google sheet. The data coming in from Glide is fine with me as long as glide is interpreting it correctly on it’s end. So in my case, even if a date came in as text, it’s fine as long as glide still treats it as a date.

I would be more curious to know what you do in the google sheet that requires it to be recognized as a date instead of text. Maybe there is some logic that can be moved to glide instead.

As for the date column, it is ridiculously flexible at interpreting dates. You can type something arbitrary, such as ‘3 days from now’ and it will convert it to a date. That text is obviously a text string, but glide is able to interpret a date from that. Manually typing a date is just typing text, so it’s sent to the google sheet as text. More on the in the thread below.

If you can explain the main problem you are having, I may have a solution. You mentioned something about sorting. Is the data not sorting correctly if a user manually enters a date through the grid? I haven’t done much yet with the grid, especially with dates and allowing users to edit dates, so I’m learning too.