问sheet.range().getRichTextValue()即使正确设置也返回null

EN

function SheetEdit(e) {
  let sheet = e.source.getActiveSheet();
  let row = e.range.getRow();
  let col = e.range.getColumn();
  let year = 2022;
  // The following getRichTextValue() returns correctly. Its text value is non-numeric.
  let folderId = sheet.getRange(row,1).getRichTextValue().getLinkUrl().split('/')[5];
  let folder = DriveApp.getFolderById(folderId);
  let filelist = folder.getFilesByName(fileName);
  if (filelist.hasNext()==true) {
    let file = filelist.next();
    let url = file.getUrl().split('?')[0]; // remove URL parameters
    // The following setRichTextValue() correctly sets the value in the spreadsheet.
    // Its text value (year) is numeric.
    let richText = SpreadsheetApp.newRichTextValue().setText(String(year)).setLinkUrl(url).build();
    sheet.getRange(row,col).setRichTextValue(richText);
    // However, the following getRichTextValue() returns null
    Logger.log(sheet.getRange(row,col).getRichTextValue().getText());
    Logger.log(sheet.getRange(row,col).getRichTextValue().getLinkUrl());
  }
}