Hi,
I was wondering if there’s a way of sorting names alphabetically in a People column when various names are added, ie. sorting needs to take place in each cell containing 1 to several names.
At the moment, when names are added from the same source list, they appear in the order they were added.
Yes it is possible normally with a formula using rank() Coda | Formulas => like this thistable.rank(thisRow,True) sort by ascending order otherwise False or
If you need more formulaic sorting that is dynamic, you would create a new column that is generated by a formula and changes based off the conditions you set, then set the sort on that column
You can also do multiple tiered sorts by accessing the tables sorting options like this screenshot
Thanks Thierry and Scott for pitching in, although it is not entirely what I want.
If you look a the screenshot, I want to sort the names in the same cell. Here, I’d like to see:
AD, C, CS, EE, L, M
And the same for all the other cells in that People column.