# CHANGELOG: May 4 / Logic in formulas, no Type restriction in Team plan

**URL:** <https://community.fibery.io/t/changelog-may-4-logic-in-formulas-no-type-restriction-in-team-plan/675>\
**Category:** Changelog\
**Created:** [May 4, 2020, 7:36am UTC](https://community.fibery.io/t/changelog-may-4-logic-in-formulas-no-type-restriction-in-team-plan/675 "2020-05-04T07:36:41Z")\
**Posts on this page:** 2\
**Page:** 1

<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:** [May 4, 2020, 7:36am UTC](https://community.fibery.io/t/changelog-may-4-logic-in-formulas-no-type-restriction-in-team-plan/675/1 "2020-05-04T07:36:41Z")

</div>

This release is modest.

## Logic and Today in formulas

Finally you can create quite interesting formulas using logic functions. Today function is also added in this release. Here are some formulas examples:

Cycle Time calculation:

```auto
If([Planned Dates].End > Today(), ToDays(Today() - [Planned Dates].Start), ToDays([Planned Dates].End - [Planned Dates].Start))

```

Generate some text field based on conditions

```auto
If((Confidence > 10) and (Reach > 10),"Important","So-so")

```

Nest if functions:

```auto
If([RICE Score] >= 15,"Cool", If([RICE Score] >= 10,"OK","Bad"))

```

Generate checkbox (for example, you may create “Fix ASAP” field with this formula)

```auto
If((Risk = "High") and (Severity = "High"), true, false)

```

## Pricing

Last month we’ve replaced some limitations on Views with limitations on Types in Team Plan (15 Types — kind of data). We had long internal discussions around this change, but finally decided to go ahead and try it.

Our stats showed that 15 types is almost always enough for a team. But we got negative feedback. It’s a psychological problem mostly, but we want to remove all barriers for teams to make a decision to convert to paying plan. So we’ve removed Type limits from all plans:

 ![Screen Shot 2020-05-03 at 11.02.44](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/3/3ae9a41eb1d5bdabe6f5fa9611f5a35b1aacaa32.png)

## Improvements

- Close popup windows using X icon on the right
- Whiteboard: Card toolbar should be hidden when I start DnD new connector
- Activity renamed to Notification

## Bug fixes

- Filter: “does not contain” does not work on relations (replaced with “is not”)
- Filter: IsEmpty filter for Decimal field is not shown correctly
- Filter by State.Final does not work in formulas
- Color block in cards looks good now when color coding is enabled

---

<div class="post-metadata">

**Author:** ![helloitse](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/helloitse/32/498_2.png) [@helloitse](https://community.fibery.io/u/helloitse)\
**Post date:** [May 20, 2020, 11:13pm UTC](https://community.fibery.io/t/changelog-may-4-logic-in-formulas-no-type-restriction-in-team-plan/675/2 "2020-05-20T23:13:25Z")

</div>

Conditional logic is much appreciated! There are a few apps I abandoned until this update. Can’t wait to check it out.
