# Nested conditional on formula

**URL:** <https://community.fibery.io/t/nested-conditional-on-formula/878>\
**Category:** Get Help\
**Created:** [August 3, 2020, 7:40am UTC](https://community.fibery.io/t/nested-conditional-on-formula/878 "2020-08-03T07:40:52Z")\
**Posts on this page:** 1\
**Showing post:** 5

<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:** [August 24, 2020, 11:55am UTC](https://community.fibery.io/t/nested-conditional-on-formula/878/5 "2020-08-24T11:55:41Z")

</div>

It’s now a whole lot easier thanks to concatenation in formulas 🙂

> [@CHANGELOG: August 24 / Text formulas, Undo in Table View](https://community.fibery.io/t/changelog-august-24-text-formulas-undo-in-table-view/908):
>
> The last two weeks were [challenging in Belarus](https://en.wikipedia.org/wiki/2020_Belarusian_protests). We slowly got back to work and released a new build with some long-awaiting features. Sorry for delays, we’re doing our best under current circumstances. fallen_leaf Text Formulas Finally you can use text in formulas. For example, create a composite text field: Name + " " + [Public Id] or create a clever URL fields: "https://www.google.com/maps/search/?api=1&query=" + Address Here is the full list of text functions Length(text) Calculat…

If( (ToDays(Today() - [Creation Date]) \> 30) and (State.Final = false) ),“🎈”,“”) + if ( (ToDays([Due date] - Today()) \> 0) and (ToDays([Due date] - Today()) \< 7) ),“⚽”,“”)

---

_[View the full topic](https://community.fibery.io/t/nested-conditional-on-formula/878)._