The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
I would like the ability to perform a “natural sort” that ignores leading articles (a, an, the). (I would like grouping to use the same logic.) The use case is that I have a database of books, and I would like “The Adventures of Huckleberry Finn”, fo...
There’s been no official answer to this topic (obviously), and no new feature yet that I know of. In the meantime, I’ve been sorting by a hidden formula field. Here’s an example formula from a book database including book series and title:
SUBSTITUTE...