To Custom Sort in Google Sheets Add a new column (for clean data). Enter the custom sort formula: =ARRAYFORMULA(SORT(A2:B12, ...