I’ve got several columns in my sheet that contain arrayformulas that insert times into columns based on form submissions in Glide. For some reason, the formatting of those columns is not being respected when new rows are added.
Is there a way to ensure the formatting in my sheet continues when new rows are added? I need these columns to not be Text, so I don’t want to/can’t use TEXT(HH:MM AM/PM) formulas.
This could also be solved by Glide recognizing date and/or time values in the editor and allowing them to be displayed as formatted dates/times.