Sort / group table with external controls

[Paul_Danyliuk]

FYI another scenario when you may want to use this is if you need to color odd/even rows, and want the colors stay regardless of sorting:

Alternating row colors

Indeed, when applying sorting on a table, the data (.First(), .Nth(…) etc) remains in the same order. But if you go this way then you’ll have your sorting applied on always that one helping column, and you can use that column in a formula to determine sort-agnostic rank: thisTable.Sort(true, Sort).Find(thisRow) https://community.coda.io/t/sort-group-table-with-external-controls/8746 P.S. Just updated the example to reflect this