I am looking to use Google Sheets to keep track of my jobs. I have a spreadsheet set up so the status of a job is indicated by a dropdown menu. When a job is completed I would select "Closed" from the drop-down. I would love for it to atomically move the entire row to another sheet upon selecting closed. This sheet would be strictly for closed jobs and keep the current sheet only for live jobs.

1 Answer 1


"...in the meantime..." solution:

paste the QUERY formula on Sheet2 and everytime you close the job, just right-click the row, select option to resize row and set it on 2px, or better - select hide row

=QUERY(Sheet1!A2:D; "select * where C='Closed'"; 0)






Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.