Google-sheets – How to indent spreadsheet cells in Google Sheets

There are a couple of ways to do that. First, you need to declare the spreadsheet:

var ss = SpreadsheetApp.getActiveSpreadsheet();  

Secondly, declare the first sheet like this:

var sh0 = ss.getSheets()[0];

or like this:

var sh0 = ss.getSheetByName("Robin");

Then set the active cell and retrieve the column index:

var editedCell = sh0.getActiveRange().getColumnIndex();

And do the logic for the sort:

var columnToSortBy = 1;
var tableRange = "a2:I30";

if(editedCell == columnToSortBy){   
  var range = sheet.getRange(tableRange);
  range.sort( { column : columnToSortBy } );
}

Complete code, a bit shortened:

function onEdit(){
  var sh0 = SpreadsheetApp.getActiveSpreadsheet().getSheets()[0];
  var editedCell = sh0.getActiveRange().getColumnIndex();

  if(editedCell == 1) { 
    var range = sh0.getRange("A2:I30");
    range.sort({column: 1});
  }
}

When you use a relative reference, such as B17, to format a range, it will be used in a relative way. That is:

• the top cell of the range, B2, gets compared to B17
• the cell below it, B3, gets compared to B18.
• B4 gets compared to B19, and so on... B7, highlighted on your example, is compared to B22 which is hidden on the sheet, but presumably B7 < B22 holds true.

If the goal is to compare all cells in the range to B17, use the absolute reference B$17 as pnuts suggested.