# \[DONE\] Allow for making formulas multi-line in formula editor

**URL:** <https://community.fibery.io/t/done-allow-for-making-formulas-multi-line-in-formula-editor/2477>\
**Category:** Ideas & Features\
**Tags:** formulas\
**Created:** [February 2, 2022, 3:58pm UTC](https://community.fibery.io/t/done-allow-for-making-formulas-multi-line-in-formula-editor/2477 "2022-02-02T15:58:43Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dimitri\_S](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/dimitri_s/32/1683_2.png) [@Dimitri\_S](https://community.fibery.io/u/Dimitri_S)\
**Post date:** [February 2, 2022, 3:58pm UTC](https://community.fibery.io/t/done-allow-for-making-formulas-multi-line-in-formula-editor/2477/1 "2022-02-02T15:58:43Z")

</div>

Using Google Sheets as an example you can do this via **Alt + Enter** and it allows for easier viewing and editing of nested formulas:

![220202-29-%pn](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/c/ccafe35b7a6d5a3c3252e617cd98c54128cf3be2.gif)

In Fibery it would be really nice if I could restructure this dense single line formula:

`If(IsEmpty([Business Name]), [Contact Name], If(IsEmpty([Contact Name]), [Business Name], [Contact Name] + " (" + [Business Name] + ")"))`

Into this easier to read formula:

```auto
If(IsEmpty([Business Name]), [Contact Name],
  If(IsEmpty([Contact Name]), [Business Name],
    [Contact Name] + " (" + [Business Name] + ")"
  )
)

```

---

<div class="post-metadata">

**Author:** ![uniquelau](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/uniquelau/32/3836_2.png) [@uniquelau](https://community.fibery.io/u/uniquelau)\
**Post date:** [February 2, 2022, 7:01pm UTC](https://community.fibery.io/t/done-allow-for-making-formulas-multi-line-in-formula-editor/2477/2 "2022-02-02T19:01:34Z")

</div>

💯 Readable code rocks 🕶

The reports (vizydrop) has this and it’s most pleasant.

---

<div class="post-metadata">

**Author:** ![DioniGR27](https://avatars.discourse-cdn.com/v4/letter/d/e495f1/32.png) [@DioniGR27](https://community.fibery.io/u/DioniGR27)\
**Post date:** [February 2, 2022, 9:23pm UTC](https://community.fibery.io/t/done-allow-for-making-formulas-multi-line-in-formula-editor/2477/3 "2022-02-02T21:23:21Z")

</div>

It seems to me that this is really a bug because it could be done in previous versions by pressing shift + enter.

The problem is that in the database view pressing shift + enter creates a new entity instead of a line in the formula.

---

<div class="post-metadata">

**Author:** ![Matt\_Blais](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/matt_blais/32/1464_2.png) [@Matt\_Blais](https://community.fibery.io/u/Matt_Blais)\
**Post date:** [June 22, 2022, 4:50pm UTC](https://community.fibery.io/t/done-allow-for-making-formulas-multi-line-in-formula-editor/2477/4 "2022-06-22T16:50:30Z")

</div>

I wish Fibery would just stop reformatting my code – both in Formulas and in Scripts! 😒

It just makes for more work when I have to reformat it again to figure out what’s going on.

---

<div class="post-metadata">

**Author:** ![mdubakov](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/mdubakov/32/10_2.png) [@mdubakov](https://community.fibery.io/u/mdubakov)\
**Post date:** [July 4, 2024, 12:51pm UTC](https://community.fibery.io/t/done-allow-for-making-formulas-multi-line-in-formula-editor/2477/5 "2024-07-04T12:51:14Z")

</div>

Done long time ago

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [October 3, 2024, 8:47pm UTC](https://community.fibery.io/t/done-allow-for-making-formulas-multi-line-in-formula-editor/2477/6 "2024-10-03T20:47:42Z")

</div>