I'm new to apps script. I'm developing a ticketing system that, from a form responses, automatically creates new spreadsheets with the right ticket on it. It works like a charm but I'm now having a problem...

I just want to know why, even if I activate the sheet opened by id, the function getCurrentCell() always return me the cell A1, even if I have a different cell selected.

This is the simple function:

function getValue() {
  var sheet = SpreadsheetApp.openById(id="").getSheetByName("Open Tickets").activate();
  var cell = sheet.getCurrentCell().getValue().toString();
  Logger.log(cell)
}

Thanks