New row added, time format not respected

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.

I can confirm I face this situation many times when I work with arrayformulas, but what you can do is to use a TEXT formula inside your arrayformula to make it work.

Though from your screenshot, it looks like what you want can be replicated in Glide using the math column.


ThinhDinh…using the TEXT formula in an array worked. I had to work to get they syntax right. I’m posting a pic and the formulas in case any one else needs this in the future. Thank you so much for the direction!!

Column R generates current time
=ARRAYFORMULA(if(ISBLANK(B2:B), “”,now()))

Column S adds 5 minutes to current time
=ARRAYFORMULA(if(ISBLANK(B2:B), “”,R2:R+0.00347222222))

Column T adds 1.5 hours to current time
=ARRAYFORMULA(if(ISBLANK(B2:B), “”,R2:R+0.06249999996))

Columns U-W convert each of those columns to text


Excellent work! You can move the arrayformula to the header though, to make sure you won’t somehow forget about it and delete line 2 :wink:

I wrote about it here.