Maybe i have an idea of why this strange behaviour happens
I think that the original table, when “recalled” with a formula is loaded as “complete table”, let me give you an example
If i have my original table (let’s call it table1) in page1 and in that page i filter it to show just some part of the table(some rows), when i create a view of that table in page2 what i get is a table identical to the original table unfiltered, so for example filter doesn’t apply in views, maybe the same behaviour take place with Sort()
To be honest i’m super curious to dig into this but i need a “dummy copy” of your doc, one that does not contain sensitive data that i can experiment with
Could you share one?
P.s. i’m not 100% sure i’ve got your situation right, maybe you was looking for a way to manually reorder the original table (table1) and find the same order in every lookup/view, in this case i would not use a “manual sorting” like moving row up and down but i would prefer to create another column with values like “1”,“2”,“3” ecc and sort that table based on this new column, but a sample doc will resolve all the dubts