Timeline for Importing only certain rows between spreadsheet documents
Current License: CC BY-SA 4.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 16, 2018 at 12:56 | comment | added | roberthuttinger | its important to note that IMPORTRANGE returns a 'mini spreadsheet' based on what you required: A2:I42. In this case 9 columns. Even if your original sheet has 20 columns, the query only has access to what columns are returned. So if the QUERY used Col12 it would throw an error because only 9 were returned. | |
| Oct 12, 2018 at 18:30 | review | First posts | |||
| Oct 12, 2018 at 22:55 | |||||
| Oct 12, 2018 at 18:29 | history | answered | roberthuttinger | CC BY-SA 4.0 |