I have a sheet with an arrayformula in one of the column headers that looks like so:
={"Short Date";ARRAYFORMULA(IF(B2:B="","",B2:B))}
Column B contains a date, formatted as yyyy-mm-dd hh:mm:ss
The arrayformula is in a separate column (N), and the column is formated as mmm dd
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?