Move rows depending of dropdown-value to another tab
Budget: $10 – $30 USD
For a project, we need to copy certain cells from a row to another tab, when a dropdown in that row is set to a specific value. It looked like we fixed this via this line of code:
=QUERY('Data'!A2:AO;"select B, D, U, AI, AJ, AN, AO, H where S contains 'Confirmed'")
The only problem is that the order of copied rows in the new tab is the same as the original tab. That's a problem because we let Zapier check when a new row is added to that tab and send out an email. And when a row gets 'inserted' between two existing rows, the Zap doesn't work. So we need to add the row at the bottom of the new tab.
I'm looking for a developer who has experience in coding with Google Sheets.
=QUERY('Data'!A2:AO;"select B, D, U, AI, AJ, AN, AO, H where S contains 'Confirmed'")
The only problem is that the order of copied rows in the new tab is the same as the original tab. That's a problem because we let Zapier check when a new row is added to that tab and send out an email. And when a row gets 'inserted' between two existing rows, the Zap doesn't work. So we need to add the row at the bottom of the new tab.
I'm looking for a developer who has experience in coding with Google Sheets.
Related categories:
Google Sheets