.First() not returning the first row in a sorted table

[Anna_F]

I even tried this

Visual Position of the row in table

Hi, here’s a tip to calculate visual position of the row in table -(if rowid, rank does not work for your case AND if you dont have ‘SORT’ applied) as you can see in image, visual position always updates based on position of the record. [VisualPosition] Formula here is Schedule.FormulaMap(if(CurrentValue = thisRow, 1, 0)).Find(1, 0) - it enumerates through each record in table, assigns 1 for the thisRow and then tries to find position of 1 in list. EDIT: - some of my colleagues pointed…

but same thing: it works when the toggle is on (reverse order, but that’s fine), and it doesn’t work when the toggle is off.

I would have never guessed this would have been so hard to make…