Sorting and skipping "The"

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!

Yes, briefly…

  1. Create a new formula field that eliminates your stop-words (i.e., the and maybe others).
  2. Sort on the formula field.

Thank You. I used the Substitute formula and that worked

1 Like

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.