Hello Mike,
Greetings! of the day. As mentioned in project description, your requirement is to implement functionality to copy specific columns in some rows from one Google sheet to another Google sheet, using Google Apps Script, as follows:
1) The rows, containing todo list, in master Google sheet, should be identified, based on status.
2) Then, the predefined columns from selected rows in master Google sheet should be copied to same location in job queues Google sheet.
I have much experience in working on different projects, using Google Sheets, Google Apps Script. Your work will be done, at the earliest, according to requirements.
Thanks.
Jai