If you made your copy of the PM Tracker before April 25th, 2019.
And if you'd like to be able to push project plans from the Staffing + Resourcing forecast up to your PM Tracker.
Then you'll need to make two small changes to your PM Tracker to allow the two to connect:
- Add a 'Reviewer' column to the right in your Tasks tab (in column L)
- Open the script editor (Tools -> Script Editor), and select the file Code.gs in the left sidebar. Replace the functions getRangeValues() and addRowToDeliverables() starting at line 117 with these functions:
function getRangeValues(row, sheet, e) {
Logger.log("in getRangeValues");
var lookup = /Review Needed/;
Logger.log(row);
Logger.log(sheet);
var rowData = SS.getSheetByName(sheet).getRange(row, 1, 1, 12).getValues();
if (rowData[0][6].search(lookup) > -1) {
addRowToDeliverables(rowData[0]);
}
addDeliverableToMasterAudit(rowData, e);
}
function addRowToDeliverables(rowData) {
Logger.log("starting addrowtolive");
var slice1 = [];
var sheetLive = SS.getSheetByName('Deliverables');
var currDate = Utilities.formatDate(new Date(), 'GMT-6', 'MM/dd/YYYY HH:mm');
var date = rowData.slice(1,2);
var deliverable = rowData.slice(3,5);
var projectStatus = rowData.slice(6,9);
var reviewer = rowData.slice(11,12);
slice1.push(date.concat(reviewer).concat(deliverable).concat(projectStatus));
var writeRow = sheetLive.getRange(1,5,sheetLive.getLastRow()).getValues().filter(String).length+1;
sheetLive.getRange(writeRow, 1, 1, slice1[0].length).setValues(slice1);
}