For my dancing lessons I tried to set up a smartlist wich gives me a set of all the ballroom dances we have to dance. After one hour I got it working:
~mix=8,25%,{[Comment]=[Cha Cha"},25%,{[Comment]=[Rumba"},25%,{[Comment]=[Samba"},25%,{[Comment]=[Jive"}
Sort: ORDER
So every Dance appears 2 times in the list. A problem I have is the sorting. They have to be sorted in the order they appear on our contests. Adding a calculated field called "ORDER" did the trick for me... nearly. This is how I did it:
If(IsEqual([Comment], Samba, 1), 01, If(IsEqual([Comment], Cha Cha, 1), 02, If(IsEqual([Comment], Rumba, 1), 03, If(IsEqual([Comment], Paso Doble, 1), 04, If(IsEqual([Comment], Jive, 1), 05, xx)
As you can see I stored the dance information in the comment tag. A Problem I don't find a solution for: a great part of my dance songs do have some extra information stored in the comment tag like "Samba (slow)" or "Samba (44 BPM)". Because of this I am using [Jive" instead of [Jive] within the smartlist. The [" doesn't work for calculated fields (or I am to stupid to use them).
So I don't get them sorted the right way. Does anyone have any idea/hint for me in this case?