[gable]

Hello,

I recently bought Mobile Sheets Pro and I think it's great. There is just one problem, though. Either, it doesn't seem like it sorts numbers in the song titles properly, or I can't figure out what option to turn on to make it do so. This is a problem because I want the songs to appear in order in the list. Here is a picture so you can see what I mean is the problem:



As you can see, it sort of sorts it according to numbers, but not properly. How do I make it sort the titles correctly? Thanks!

[Zubersoft]

If you tap "Sort" at the top and change it to "Sort: Numerically", does that get you the sort order you are looking for?

Mike

[gable]

Yes that did it! Didn't realize there were more options there, and had trouble figuring out what I should search for in the manual to find what I needed. I was looking around in settings haha. And it seems the app remembers what I chose last time when I open it again, awesome! Thank you

[Zubersoft]

Happy I could help!

Mike

[alternativepets]

Can someone please tell me how to get my library of setlists sorted by year, then month, then day(s)? This is how I successfully label and sort my files in Windows 10, but in MobileSheets (iPad) the decimals mix up everything:

Current sorting (numerically descending):

year.month.day(s)
2024.12.14-15
2024.6.20-21
2024.11.9-10
2024.1.9-12
2024.12.4-7
202412.20
2023.12.24
2023.12.17
2023.12.16
2024.6.29
2024.6.27
2024.6.24
2024.6.22
2024.6.15
2024.6.13
2024.4.21
2024.4.13
2024.3.23
2024.3.14
2024.2.19
2024.2.10
2024.5.6
2024.2.9

[Zubersoft]

Can you use slashes or dashes instead of periods for the dates? Or even a space. I think that would probably resolve the sorting issue. Otherwise alphabetic sorting may actually work better than numeric if you make sure to always use the same number of characters, i.e. 2024.01.09 instead of just 2024.1.9. I can try to look into why that's breaking the numeric sorting algorithm though, but I would have thought the same problem would exist on Windows as it uses the same underlying code (just written in a different programming language).

Mike

[Zubersoft]

The issue is due to the fact that MobileSheets strips punctuation while sorting, so the numbers become much larger numbers, i.e. 20231217 compared to 20241220, so it's sorting based on those numbers. If you placed a space between them, that would work without issue. Or if you make sure to always use two digits for the day and month as I suggested above (2024.01.09) that would also ensure that the numbers are always processed correctly. The other benefit of doing that is that the width of the dates will always be consistent, potentially making it more visually pleasing.

Mike

[itsme]

With dates in yyyy-mm-dd format as specified in ISO 8601 sorting of setlists works fine
https://en.wikipedia.org/wiki/ISO_8601

For sorting songs specifying "Sort Title" entries for your songs could achieve whatever you want. "Sort Title" overwrites existing alfabetical sorting rules for titles in lists. You might need to make it visible on the "Fields" tab of the song editor by activating it in the three dots menu under "Configure Fields". "Sort Title" is not shown in lists unless you configure it via Settings - Library Settings - Song Title Formatting"
The song from the screenshot is sorted in lists under A whereas it is displayed as "(Der) Aberglaub'n"