Untitled
unknown
javascript
3 years ago
425 B
25
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...