Adds 3 tables

PHOTO

Mon May 23 2022 22:27:38 GMT+0000 (Coordinated Universal Time)

let summaryTable = sheet.addTable("Q2:U2", true);
  summaryTable.getHeaderRowRange().setValues([["Label", "Name", "Billable", "Non-Billable", "Drive Time"]]);
  summaryTable.setPredefinedTableStyle("TableStyleLight1");
  summaryTable.setShowBandedRows(false);
  summaryTable.setShowFilterButton(true);
  summaryTable.getRange().getFormat().autofitColumns();
  let summaryTable2 = sheet.addTable("W2:Z2", true);
  summaryTable2.getHeaderRowRange().setValues([["Location", "Billable", "Non-Billable", "Drive Time"]]);
  summaryTable2.setPredefinedTableStyle("TableStyleLight2");
  summaryTable2.setShowBandedRows(true);
  summaryTable2.setShowFilterButton(false);
  summaryTable2.getRange().getFormat().autofitColumns();
  summaryTable.setName("SummaryTable");
  summaryTable2.setName("SummaryTable2");
 
 let errorTable = sheet.addTable("W7", true);
  errorTable.getHeaderRowRange().setValues([[ "Issues"]]);
  errorTable.setPredefinedTableStyle("TableStyleLight3");
  errorTable.setName("Issues");

COPY