Forum Discussion
Auto sort help needed
Hi All- I have a spreadsheet where I want it to sort by status, column J, but I would like it to auto sort so anytime I add a new candidate the sheet automatically updates the sort when I add their s...
You cannot auto sort your source table, however you can create a formula in another sheet that references your source table and using the SORT() or SORTBY() functions will auto sort the spilled output of your dynamic subset. Another solution you can try is power query where you can set the sort order and the resultant query will always be sorted the way you set your query up:
References:
https://youtu.be/kOTyjQ1jFZA
https://exceljet.net/lessons/sort-and-sortby-with-multiple-columns?wvideo=mdnm19g7sj
https://youtu.be/9W2mlLgfwwA