GAS – Move “Completed” Rows to separate sheet

Very often I create a google form and then need to complete further columns to give feedback or show progress. These can become unwieldy after a short time, so it helps to clear out and archive the finished rows to another sheet. In the example below there is a column that needs to contain “Yes” in order to be moved to the Completed sheet

Leave a Reply

Your email address will not be published. Required fields are marked *