Google Sheet Code (Javascript)Link: https://docs.google.com/spreadsheets/d/1oNwWnIrmW5alBsXiKDwDu0ImIgdzb81HBwuGa-qBb00/edit?usp=sharingI would like a row in sheet1 (main) to be copied from column A to K when a certain condition is entered in cell L of that row, If column L contains ‘up’ is should be copied to the next available row sheet2 (Sub). if column L on sheet1 (Main) is changed from ‘up’ to ‘down’ then should be removed from Sheet2 (Sub) and copied to Sheet3 (Done) and vice versa.
you will find bellow a code, but its not working its copying allthe entries from Sheet( Main ) Either up or down to only Sheet(Done ).
Code:function
OR
PayPal Gateway not configured
OR
PayPal Gateway not configured