Insert Formulas with the Insert row action

From what you wrote I believe arrayformula will solve your problem. Put this in your first row (header row).

={"Formatted date";ARRAYFORMULA(IF(B2:B<>"",TEXT(B2:B,"YYYY-MM-DD"),""))}

Regarding the insert row action, it’s working the right way because it’s suppose to insert text/number, not a formula.

1 Like