SKRIPT
Funkce getSheetName
a spouštění skriptu kliknutím na objekt

function getSheetName() {

  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();

  return sheet.getName();

}

function aktualizace1() {

  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();

  var activeCell = sheet.getActiveCell();

  var adjacentCell = activeCell.offset(-1, 0);

  var originalFormula = activeCell.getFormula();

  var adjacentValue = adjacentCell.getValue();

  adjacentCell.setFormula(originalFormula);

  activeCell.clearContent();

  var movedFormula = adjacentCell.getFormula();

  activeCell.setFormula(movedFormula);

  adjacentCell.setValue(adjacentValue);

}