How do you sort dropdown values?

Hi!

I’m looking for a way to sort how dropdown values show up. I reviewed this documentation, but couldn’t find it anywhere nor in the videos.


Ideally, I’d like it to load:
Cantrip
1st
2nd
3rd

9th

I tried using the sort option but could never get it to work.

FYI, I was able to use the AI to generate the formula for creating the lists in the first place. It appears to be working, and I wouldn’t have been able to come up with that on my own.

Thanks a bunch!

-Brendan

You might want to try these ones, they’re pretty powerful. Or is it the thing that didnt work for you? Could you show how you’re sorting it?

I don’t know what ABC 0 refers to, but I can get it closer to what I’m looking for. I want to start with cantrip though, rather than have it at the bottom.

Hmm, how about you sort the data from the collection directly, and then apply any other modifications?

At present, I only have one collection which pulls the whole dataset. I assume I’d need to split this one off and make it separate, as the rest of the data I want sorted by name.