0

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.

4

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.