Timeline for Google Sheets - Using IMPORTRANGE with a variable number of rows
Current License: CC BY-SA 4.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 7, 2020 at 17:04 | comment | added | marikamitsos | You are now free to upvote. | |
| Feb 6, 2020 at 21:38 | vote | accept | Kevin R | ||
| Feb 6, 2020 at 21:14 | comment | added | MattKing | nice chatting on the sheet. good luck. | |
| Feb 6, 2020 at 21:04 | answer | added | MattKing | timeline score: 4 | |
| Feb 6, 2020 at 20:45 | history | edited | Kevin R | CC BY-SA 4.0 |
added 361 characters in body
|
| Feb 6, 2020 at 20:30 | comment | added | MattKing | ok, i think i can do it for you. want to make up a few more example sheets and paste in their links to the correct column in the database? I think 4 ought to be enough to test the idea. | |
| Feb 6, 2020 at 20:19 | comment | added | Kevin R | The maximum number of rows that it would pull would be 30. On average I would expect the number of rows to be less than 10. On the actual project, it would be 5 total columns rather than the 4 I used in the example. | |
| Feb 6, 2020 at 20:14 | comment | added | MattKing | It's possible there's a scripting solution to this, but i have a workaround that could work depending on the actual size of the pulls that are getting made by the query. How many rows, on average, are getting pulled by your query? And is is just the 4 columns? | |
| Feb 6, 2020 at 19:15 | review | First posts | |||
| Feb 6, 2020 at 19:30 | |||||
| Feb 6, 2020 at 19:10 | history | asked | Kevin R | CC BY-SA 4.0 |