Found out that if there are blank characters in the data, it will take those blank characters into account when sorting the records. To remove the blank characters from 6k+ records, I created a new Formula field that pointed to the field I needed to ...

I am having the same issue. It is making it difficult to do my work because the sort feature only seems to sort correctly with one field. When I add a second field to sort, it doesn't sort as it should. In my case, I need the fields to sort by Year a...