Is there a Google Sheets Script to change row height based on a trigger?

Question

I am looking for a script that if any row's cell in say column C is not blank then I want that row's height to be set to 200 if it is blank then set height to "Fit to Data". Thanks in advance

Answer 1

To force a row height of 200 pixels, use Sheet.setRowHeightsForced(). To get Fit to data, use sheet.setRowHeight() and set the row height to the default of 21 pixels. Note that this method never makes the visible row height less than the default row height even when the data would require less.

Here's sample code that resizes rows as you edit column C in row 63 or below in sheet 'Contract':

/**
* Simple trigger that runs each time the user hand edits the spreadsheet.
*
* @param {Object} e The onEdit() event object.
*/
function onEdit(e) {
  if (!e) {
    throw new Error(
      'Please do not run the onEdit(e) function in the script editor window. '
      + 'It runs automatically when you hand edit the spreadsheet.'
    );
  }
  autoChangeRowHeight_(e);
}


/**
* Changes row height depending on whether column C is blank.
*
* @param {Object} e The onEdit() event object.
*/
function autoChangeRowHeight_(e) {
  let sheet;
  if (e.range.columnStart !== 3
    || e.range.rowStart < 63
    || !(sheet = e.range.getSheet()).getName().match(/^(Contract)$/i)) {
    return;
  }
  if (e.value) {
    sheet.setRowHeightsForced(e.range.rowStart, 1, 200);
  } else {
    sheet.setRowHeight(e.range.rowStart, 21);
  }
}