When running the function:
function updateCells() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var spreadsheetSummary = ss.getSheetByName('Summary');
const range = spreadsheetSummary.getDataRange()
const values = range.getDisplayValues()
const transposeCheck = values(0).map((_, iCol) => values.map(row => row(iCol)).some(cell => cell))
var countBoolean = transposeCheck.filter(Boolean).length + 1
var spreadsheetCommunityGroups = ss.getSheetByName('Community Groups');
var cellValueCommunityGroups = spreadsheetCommunityGroups.getRange('A12').getValue();
var summaryCommunityGroups = OFFSET('B'+countBoolean, 0, 1);
spreadsheetSummary.getRange(summaryCommunityGroups).setValue(cellValueCommunityGroups);
}
I receive the error ReferenceError: OFFSET is not defined
.