Tengo este script a continuación, que envía por correo electrónico a la persona una copia de todas sus tareas asignadas que no están completas. Sin embargo, me gustaría omitir todas las tareas donde el estado de los proyectos principales es "atraso". Aquí está mi código actual y un enlace a una copia de las tablas:

 function sendEmails() { // Retrieve Project IDs, Project names and Project Status const project = sheetITPM.getRange("A2:J" + sheetITPM.getLastRow()).getValues().map(r => ({ id: r[0], name: r[1], status: r[2]})); //get Tasks Sheet and all rows needed let s = ''; const sh = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("ITPM_Tasks"); const lastRow = sh.getLastRow(); const startRow = 2; // First row of data to process const numRows = lastRow - 1; // Number of rows to process const rg = sh.getRange(startRow, 3, numRows, 6); const vs = rg.getValues(); let oners = {pA:[]}; //function to NOT include projects with status: "backlog" //dont include tasks with status "Complete" vs.forEach((r,i) => { let [name,desc,status,owner,due] = r; if(status != 'Complete') { if(!oners.hasOwnProperty(owner)) { oners[owner]=[]; oners[owner].push(r); oners.pA.push(owner) } else { oners[owner].push(r); } } }); //email subject and start message let subject = 'IT Board - Weekly Reminder: The following tasks are assigned to you.'; oners.pA.forEach(p => { let msg = `These Tasks below are assigned to you:\n` //task array oners[p].forEach((r,i) => { let [name,desc,status,owner,due] = r; msg += `Task - ${i+1}\n`; msg += `Description: ${desc}\n`; msg += `Due Date: ${due}\n\n` }); msg += `notify the IT Project Management Team of any updates\n\nThank You`; //send email to the task owner with their task array + subject + our message MailApp.sendEmail(oners[p][0][3], subject, msg); }); }

Enlace a la hoja: https://docs.google.com/spreadsheets/d/1aGojtDy9sDpGexiT_ixF_H_95GG_uiYeAkNUWzYkKSE/edit?usp=sharing