Hi All! I have been having an issue with sorting any data by date in a descending order. Even if I use a single sorting expression in a formula I always get an ascending list. Eg.: Runs.Filter([Creation Date] >= Today() - Days(15)).Sort(Finished, false) will result the same list as Runs.Filter…

The Sort() function is normally only used in formulas when followed by First() or Last(), in order to get the highest/lowest item . It has no effect on how a collection is displayed on the UI. Sorting of a collection is a UI-only thing, and for formulas that result in a collection, it is not possibl…

Thank You, Chr1sG for the quick answer. Albeit the reasoning surprises me as it would mean I can create views and sort its items any way I want, but I am unable to use the same feature in a formula to display the relevant information. Interesting. Thanks again for the help!

We have a feature in the backlog to make collections that are the result of formulas, behave like regular relation fields on the UI (sort, filter, color-code) which will probably solve this

[image] Inconsistent formatting of Collection fields in entity views Bugs & Issues Not sure how much of this is intentional, but the inconsistency looks unprofessional. Different font size and weight between field name of collection lookups vs. native collections Differe…

That is some great news, I am looking forward to seeing it. Thanks again!

Is there a way we can vote on this feature? I notice the original post is a bug report that has come up in several threads now.

If you’re encountering the problem described in this topic, then the solution will be supporting normal collection field behaviour for formulas/lookups, which is what is described in the topic mentioned above, so voting on that topic will be enough.

Unable to sort decending

Bugs & Issues

Chr1sG November 14, 2024, 8:48am 5

Topic		Replies	Views
Sort and filter on the Lookup field Get Help	6	462	September 5, 2025
How to sort by multiple fields in a formula Get Help	3	231	November 8, 2023
Slice and Sort lookup fields	2	44	September 11, 2025
CHANGELOG: Oct 27 / Sort() and First() in formulas, Undelete Types and Fields, Delete Workspace, Pen Changelog	21	1709	January 9, 2023
Sort() doesn't work Get Help	1	187	September 17, 2023

Unable to sort decending

Related topics