Alright so I found this thread How to sort a table based off status text values? - #2 by Paul_Danyliuk which is somewhat more helpful. The solutions proposed do work, but it still seems hacky.
I wonder, since that thread is 2 years old now, has anything new been implemented to improve this, or is a hack still the only way to do it?
Thanks!