Reddit help

function onOpen(e){
  const menu = SpreadsheetApp.getUi().createMenu('Template')
    .addItem('Run','findWord')
    .addToUi()
}

function findWord() {
  const ss = SpreadsheetApp.getActiveSpreadsheet()
  const inputSheet = ss.getSheetByName('Sheet29')
  const templateSheet = ss.getSheetByName('Template')
  const dValues = inputSheet.getRange(1,4,inputSheet.getLastRow(),1).getValues().flat()

  let rowNumber;

  for (i=0; i < dValues.length; i++){
    rowNumber = i
    if(dValues[i].includes('Screen')){
      break;
    }
  }

  const date = Utilities.formatDate(new Date(values[0][0]), 'GMT+6', 'yyyy-MM-dd HH:MM:SS')
  const values = inputSheet.getRange(rowNumber + 1,2,1,2).getValues()
  templateSheet.getRange("C28").setValue(`Date/Time: ${date}`)
  templateSheet.getRange("C30").setValue(`Class: ${values[0][1]}`)

}