Untitled

 avatar
unknown
javascript
2 years ago
425 B
19
Indexable
function CenterAlignAllDashes() {
  const sh = SpreadsheetApp.getActiveSheet();
  var sheet = SpreadsheetApp.getActiveSpreadsheet();
  var sheetByName = sheet.getSheetByName("Database");
  sheetByName.getRange(2, 7, sheetByName.getLastRow(), 1).getValues().flat().forEach((v, i) => {
    if (v == "CH") {
      sheetByName.getRange(2, 8, sheetByName.getLastRow(), 1).setHorizontalAlignment("center");
    }
  });
}
Editor is loading...