Multiple on edit in one gsheet

Question

I'm trying to create a spreadsheet for my team, and using this script I am only getting one of the on edit if statements to function. How can I fix this? I'm not very versed in script writing.

function onEdit(e) {
  const sh=e.range.getSheet();
  if(sh.getName()=='Confirmation Check' && e.range.columnStart==8 && e.value=='TRUE') {
    var resp=SpreadsheetApp.getUi().alert('REMINDER: Did you update the P.5 with the initiation date?', SpreadsheetApp.getUi().ButtonSet.YES_NO);
    if(resp==SpreadsheetApp.getUi().Button.YES) {
      if(e.range.columnStart >8) return;
      e.source.getActiveSheet().getRange(e.range.rowStart,9).setValue(new Date());
      return;
      if(sh.getName()=='Confirmation Check' && e.range.columnStart==6 && e.value=='TRUE') {
        var resp=SpreadsheetApp.getUi().alert('REMINDER: Did you update the P.5 with the authoritzation date?', SpreadsheetApp.getUi().ButtonSet.YES_NO);
        if(resp==SpreadsheetApp.getUi().Button.YES) {
          if(e.range.columnStart >6) return;
          e.source.getActiveSheet().getRange(e.range.rowStart,7).setValue(new Date());
          return;
        }
      }
    }
  }
}

Answer 1

Use Range.offset() to get the next cell to the right, and observe onEdit(e) best practices, like this:

/**
* Simple trigger that runs each time the user hand edits the spreadsheet.
*
* @param {Object} e The onEdit() event object.
*/
function onEdit(e) {
  if (e.value !== 'TRUE'
    || ![6, 8].includes(e.range.columnStart)
    || e.range.getSheet().getName() !== 'Confirmation Check') {
    return;
  }
  const ui = SpreadsheetApp.getUi();
  const response = ui.alert('REMINDER: Did you update the P.5 with the initiation date?', ui.ButtonSet.YES_NO)
  if (response !== ui.Button.YES) {
    return;
  }
  e.range.offset(0, 1).setValue(new Date());
}

Answer 2

You should check the openings and endings of the if and else cycles, that was why it wasn't working. Try this:

function onEdit(e) {
const sh=e.range.getSheet(); 
  if(sh.getName()=='Confirmation Check' && e.range.columnStart==8 && e.value=='TRUE') {
    var resp=SpreadsheetApp.getUi().alert('REMINDER: Did you update the P.5 with the initiation date?', SpreadsheetApp.getUi().ButtonSet.YES_NO)
    if(resp==SpreadsheetApp.getUi().Button.YES) {
        //if(e.range.columnStart>8) return --> You've already checked number of column
        //else {}
        e.source.getActiveSheet().getRange(e.range.rowStart,9).setValue(new Date()); return;} 
        //}
    else return }
  
  else if(sh.getName()=='Confirmation Check' && e.range.columnStart==6 && e.value=='TRUE') {
    var resp=SpreadsheetApp.getUi().alert('REMINDER: Did you update the P.5 with the authorization date?', SpreadsheetApp.getUi().ButtonSet.YES_NO)
    if(resp==SpreadsheetApp.getUi().Button.YES) {
        //if(e.range.columnStart>6) return --> You've already checked number of column
        //else {}
        e.source.getActiveSheet().getRange(e.range.rowStart,7).setValue(new Date()); return;} 
        //}
    else return }
}

Answer 3

I am offering this answer simply because it uses the syntax and style of your original script. This may help with the transition to a more sophisticated solution.

---

function onEdit(e) {
  const sh=e.range.getSheet()
  if(sh.getName()=='Confirmation Check' && e.value=='TRUE'&& (e.range.columnStart==8 || e.range.columnStart==6) ){
    var resp=SpreadsheetApp.getUi().alert('REMINDER: Did you update the P.5 with the initiation date?', SpreadsheetApp.getUi().ButtonSet.YES_NO);
    if(resp==SpreadsheetApp.getUi().Button.YES) {
      e.source.getActiveSheet().getRange(e.range.rowStart,e.range.columnStart+1).setValue(new Date());
    }
  }
}