I don't look for =ImportRange because I want to stay within the same Google Sheets spreadsheet. Instead, I want to import a column from one sheet into a column of another sheet within the same spreadsheet.
How can I import a column from one sheet into another sheet of the same Google Sheets spreadsheet?
google spreadsheets
One way to do this is with =ArrayFormula. If the sheet you want to import from is named Sheet1 and you want to select the entirety of column A, you can do the following:=ArrayFormula(Sheet1!A:A)You can see an example of this in action here: https://docs.google.com/spreadsheets/d/1kJraNDzrLF8-W_BxbL8pU6e_QuoMqFcl_sgyzT14L2Y/edit?usp=sharingIn general you can use the form [SheetName]![Range] to pull in data from another sheet from within the same spreadsheet. In this case, ArrayFormula is needed to expand the entire range instead of just importing the first cell in the range.