I have a sheet with an arrayformula in one of the column headers that looks like so:
Column B contains a date, formatted as
The arrayformula is in a separate column (N), and the column is formated as
So essentially I’m just taking the long date, copying it to another column and reformatting.
The arrayformula works fine, BUT… every time a row is added to the sheet, it breaks
I’ve checked and re-checked, and I’m 99.99% certain that nothing is being written to that column when a row is added. So I’m stumped.
Anyone encountered this problem before?