Hello,
Is there a way to sort by name, but ignore “The” in the sort calculation. I am trying to sort albums with a Artist + Album field and would like the sorting to ignore “The” in the artist name.
Solved
Sorting and skipping "The"
Best answer by Joel_D_Eon
Hi Joel, and welcome to the community!
Yes, briefly…
- Create a new formula field that eliminates your stop-words (i.e., the and maybe others).
- Sort on the formula field.
Thank You. I used the Substitute formula and that worked
Hi Joel, and welcome to the community!
Yes, briefly…
- Create a new formula field that eliminates your stop-words (i.e., the and maybe others).
- Sort on the formula field.
Hi Joel, and welcome to the community!
Yes, briefly…
- Create a new formula field that eliminates your stop-words (i.e., the and maybe others).
- Sort on the formula field.
Thank You. I used the Substitute formula and that worked
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.