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

Reply


Terms & Conditions