# Filtering and getting first element

**URL:** https://community.fibery.io/t/filtering-and-getting-first-element/948
**Category:** Get Help
**Tags:** formulas
**Created:** [September 2, 2020, 4:46pm UTC](https://community.fibery.io/t/filtering-and-getting-first-element/948 "2020-09-02T16:46:18Z")
**Posts on this page:** 1
**Showing post:** 14

<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: [November 11, 2021, 11:48am UTC](https://community.fibery.io/t/filtering-and-getting-first-element/948/14 "2021-11-11T11:48:23Z")

</div>

Implemented already [CHANGELOG: Oct 27 / Sort() and First() in formulas, Undelete Types and Fields, Delete Workspace, Pen](https://community.fibery.io/t/changelog-oct-27-sort-and-first-in-formulas-undelete-types-and-fields-delete-workspace-pen/2156)

```auto
Epics.Sort(Name).First().Name

Companies.Sort([Creation Date], false).First().Contacts.Count()

Companies.Sort(Name).First().Country.Name

```

---

_[View the full topic](https://community.fibery.io/t/filtering-and-getting-first-element/948)._