I've got a script that sorts a Google Spreadsheet when a value in a column is changed.
I'd like to add to the script the following functionality:
If the value for column E = "Complete" then the entire row is moved to a different spreadsheet (that is a different tab in the same Google Spreadsheet document).
The row would either be inserted, or appended to the bottom of the spreadsheet in the first blank row.
Is this possible?