'Linked sheet with new columns + manual edits
I have a sheet with rows prepended by an app (call this primary sheet). I want to create a secondary sheet that will auto update when the primary sheet is updated. I also want the secondary sheet to have additional columns in which specific cells are updated manually.
For example: Primary Sheet
Header1 Header2
row21 row22
row11 row12
Secondary Sheet
Header1 Header2 Status Updates
row21 row22 New blah1
row11 row12 Done blah2
...where "Status" and "Updates" columns are updated manually.
I have tried using =IMPORTRANGE("https://docs.google.com/spreadsheets/d/xxx","PrimarySheet!A:B") and =query(PrimarySheet!A:B, "select * where B contains 'blah' ") but I can't seem to get the Status and Updates field to move down with Header1 & Header2. For example:
Secondary Sheet
Header1 Header2 Status Updates
row41 row42 New blah1
row31 row32 Done blah2
row21 row22
row11 row12
I'm hoping the Secondary Sheet should be:
Header1 Header2 Status Updates
row41 row42
row31 row32
row21 row22 New blah1
row11 row12 Done blah2
Any suggestion on how to get the desired outcome?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
