When sorting a Choice column, it’d be great if we can sort by the label order (assigned by the user), not just alphabetically.
1 Like
Ooh, makes sense! Thanks for sharing the idea.
You can do this by hacking into Grist with an extra formula like this:
import json
column = _grist_Tables_column.lookupOne(tableId="Table2", colId="A")
json.loads(column.widgetOptions)["choices"].index($A)
This gives the position of $A
within the choices of the column A
in Table2
, so you can sort by that.
2 Likes
Thanks, but somehow I can’t make it work…
I think I’m doing exactly that, but it’s still not sorting… by the way, can you please make the formula “box” bigger?
- The formula I gave will only work for Choice columns. A different formula is needed for Choice List columns. What do you need?
- The formula needs to be in a separate column from the Choice column. It returns a number which is the position of the choice. That’s the column to sort by. You’ve put the formula in the same column which means something different (Intro to formulas - Grist Help Center)
This is why I requested a feature that a layperson can use. Not a developer here…
Update: @school
You can now sort a Choice column by the label order in the choice editor. When sorting a Choice column, click on the three dots to open a menu of additional features. “Use choice position” sorts by label order.
3 Likes