Untitled
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...