Skip to main content
Question

Sorting TextList in formula

  • January 21, 2022
  • 0 replies
  • 237 views
Any option to sort a Text list with words in alphabetical order? 

I need to sort something like this: BB;CC;AA;DD;EE;GG;FF to AA;BB;CC;DD;EE;FF;GG in a formula.

I'm currently looking at using Part to break the list into individual elements then use Min to look for the elements and extract the first word, but then I need to recreate the list minus the word I already found, this need to happen for every word (max 20)
I'm already in like 40 with no end in sight

Am I on the right track? 
Any help will be appreciated.

------------------------------
Saar Litman
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
What is the source of the text list?  Is it a multi select field?  or a combined text Summary or the result of a Formula Query - I'm thinking the latter which is sorted by Record ID#.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
Forum|alt.badge.img+6
  • JoelHickok
  • Registered
  • December 27, 2022
I have the same need as well.  Based on my investigation, this is not possible in a Formula.  If you have figured out a solution, please share, but it really does not seem possible at this time.  None of the existing Formula functions offer the tools to sort.

For how powerful Quickbase is, there are always very obvious holes in the product and chinks in the armor.  Still a very good product!
Terms & ConditionsAccessibility statement