IMPORTANT: If you're using the Blueprint PM Tracker

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:

  1. Add a 'Reviewer' column to the right in your Tasks tab (in column L)
  2. 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);

}

Module 7.0 - Agency Staffing + Resourcing

Already enrolled?
Sign in to continue learning.