Google-sheets – Sort column from another sheet alphabetically

google sheets

I have a sheet that has a column of names. I want to have another sheet that copies all of the entries from this column in sheet 1 and alphabetizes them automatically as I add new entries into sheet 1. How can I do this?

Best Answer

I figured it out. I used

=ARRAYFORMULA(SORT(Sheet1!A2:A))