I have an array formula active in many of my columns in Google sheet.
When an action adds a new row to the sheet, the date and time is correct, but formatted wrongly. It is appearing as numbers, like 44231 instead of 2/4/2021 and 0.9375 instead of 10:30PM. The issue is that when it appears as a number instead of date/time in Google sheets, Glide doesn’t recognize it as a date/time.
How do I force my array formulas to formatt correctly as dat and time?