# Sort and filter on the Lookup field

**URL:** <https://community.fibery.io/t/sort-and-filter-on-the-lookup-field/3788>\
**Category:** Get Help\
**Created:** [January 9, 2023, 1:31pm UTC](https://community.fibery.io/t/sort-and-filter-on-the-lookup-field/3788 "2023-01-09T13:31:14Z")\
**Posts on this page:** 1\
**Showing post:** 6

<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:** [September 5, 2025, 2:52pm UTC](https://community.fibery.io/t/sort-and-filter-on-the-lookup-field/3788/6 "2025-09-05T14:52:31Z")

</div>

The `Sort()` function in formulas is not related to the sorting that is used when displaying collections.  
It is typically used for when you want to extract the `First()` or `Last()`, or do something like `Join()` as you discovered.  
But formulas utilise ‘backend’ functions, and they do not affect the ‘frontend’ display of the result.  
Ultimately, the fix will come when it is possible to use the standard relation field component to display a collection of entities which are the result of a formula.  
See [here](https://community.fibery.io/t/inconsistent-formatting-of-collection-fields-in-entity-views/4040).  
In that case, users will be able to set frontend filters and sorting on collections which are read-only.

Related: [Unable to sort decending](https://community.fibery.io/t/unable-to-sort-decending/7792)

---

_[View the full topic](https://community.fibery.io/t/sort-and-filter-on-the-lookup-field/3788)._