Hey I have an issue with date in the Glide interpretation of the sheet.
I am using a text function to format the dates to DD-MM-YYYY but it is still chopping and changing from DD-MM-YYYY to MM-DD-YYYY in Glide from column to column despite all of the columns being formated.
When you say all the columns have been formatted, are you referring to the columns in the Glide Data Editor? Regardless of how your spreadsheet columns are formatted, you will need to ensure the same columns are also formatted as date/time type in Glide.
Note that although Glide might initially recognise the columns as date/time, it doesn’t always get the format right. It’s always a good idea to edit the column and make sure.
For specific formatting options, there is a Format Date plugin. However, take care with that as I’m aware that it doesn’t always play well with non-US date format/locale.