# Insert Formulas with the Insert row action

**URL:** <https://community.glideapps.com/t/insert-formulas-with-the-insert-row-action/28438>\
**Category:** Ask for Help\
**Created:** [June 28, 2021, 10:24am UTC](https://community.glideapps.com/t/insert-formulas-with-the-insert-row-action/28438 "2021-06-28T10:24:46Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [June 28, 2021, 11:06am UTC](https://community.glideapps.com/t/insert-formulas-with-the-insert-row-action/28438/2 "2021-06-28T11:06:29Z")

</div>

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

```auto
={"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.

---

_[View the full topic](https://community.glideapps.com/t/insert-formulas-with-the-insert-row-action/28438)._