'How to attach new data onto queried row in Google Sheets
I'm trying to think of the best way to ask this - hope this makes sense.
I am trying to build a spreadsheet where the first tab holds all new client referrals which then sends the entries marked "approved" to the next tab, and then the next tab will hold all of the approved entries assigned to a specific team. I've been able to do that through query, but where I am stuck is when I try to add new data in the second and third tabs. For example - an entry is marked as approved which sends it to the second sheet, and assigned a team which sends it to the third sheet but then I would like to be able to add new data to the same row and attach it so that if the entry is removed from the first tab the new data in that row (not just the queried data) will be removed also.
Is that possible? Does that even make sense..?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|