Say I have a Sheet with people info, containing their names and some other info. I add a filter to this Sheet to be able to sort alphabetically by lastname, or any other column.
Now I want to add more columns, but adding them in the same Sheet makes it difficult to visualize since we might have already a lot of columns. Using a different Sheet for that seems like a good idea.
I create a new Sheet called "Positions" to add their work positions and use
ARRAYFORMULA to copy the Names and Lastnames columns. Then I add a new column for Position.
The problem comes when I change the order in the original Sheet. If I set the order to be Z-A on lastname, the Position Sheet columns for Lastname and Firstname will change, but the Position column will not, and I will have a mismatch of the information.
Is there any way to achieve this?