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.
Hi Joel, and welcome to the community!
- 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
This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.