I'm trying to apply this script to a specific tab to not ruin all the other tabs.
function onEdit(e) {
let range=e.range;
let activeRow = range.getRow();
let activeColumn = range.getColumn();
let cellValue = range.getValue();
let sheet = SpreadsheetApp.getActiveSheet();
if (activeColumn == 9) {
if (cellValue == false) {
sheet.getRange(activeRow,8).clearContent();
} else {
sheet.getRange(activeRow,8).setValue(new Date());
}
}
}