Skip to main content

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.

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.

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

Terms & ConditionsAccessibility statement