# CHANGELOG: September 24 / Some new formulas and some fixed bugs

**URL:** <https://community.fibery.io/t/changelog-september-24-some-new-formulas-and-some-fixed-bugs/1011>\
**Category:** Changelog\
**Created:** [September 24, 2020, 8:42am UTC](https://community.fibery.io/t/changelog-september-24-some-new-formulas-and-some-fixed-bugs/1011 "2020-09-24T08:42:04Z")\
**Posts on this page:** 1\
**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:** [September 24, 2020, 8:42am UTC](https://community.fibery.io/t/changelog-september-24-some-new-formulas-and-some-fixed-bugs/1011/1 "2020-09-24T08:42:04Z")

</div>

## New formulas: Join, Middle, Find, Greatest, Least, CountUnique, IsEmpty

**Join(expression, delimiter)**

Combines text values from a collection of entities into a single text

`Assignees.Join(Name, ', ')`

**Middle(text, startAt, numberOfCharacters)**

Extracts the desired number of characters from the middle of the text

`Middle("Umbrella", 5, 4)`

**Find(text, searchFor)**

Finds the first occurrence of the string in the text

`Find("Where's Waldo?", "Waldo")` → 8

**Greatest(value1[, value2, value3,…])**

Calculates the largest number or the latest date across several values

`Greatest(Appointments.Max([Creation Date], Drugs.Max([Creation Date])), Comments.Max([Creation Date]))`

**Least(value1[, value2, value3,…])**

Calculates the smallest number or the earliest date across several values

`Least(Appointments.Max([Creation Date], Drugs.Max([Creation Date])), Comments.Max([Creation Date]))`

**CountUnique(expression)**

Counts the number of unique values in a collection of entities

How many teams work on Feature across all User Stories?

`Stories.CountUnique(Team.PublicId)`

**IsEmpty**

Checks whether value is empty

`IsEmpty("")` → true

## Whiteboard View: round corners for boxes

Nothing spectacular, but still aesthetically pleasing:

 ![2020-09-24 11.41.25](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/8/88bf9b445a30a3adac3aa5d4808ea9784ff3c111.gif)

## 🦐 Fixed Bugs

- Reports: Report templates don’t display for automatically selected external apps
- Reports: It’s getting impossible to create new charts once you create a report from Trello app
- Close mention popup when a user inserts another ‘#’ after ‘#’
- Documents: when an entity is deleted, the mention becomes ugly
- Formula: Wrong result (true) of MatchRegexfunction if the first parameter is text and the second parameter is empty
- Formula: IF formula calculating a relation always produces an falsy value
- Search: arrows hotkey also scrolls Entity View in linked highlights
- Safari: Lanes filter crushes on the Board View in the Safari browser
- Add “Copy URL” to view as well (at least Document)