How to get a link from a cell in Google Sheets with a script?

Question

Google Apps Script

function myFunction() {
  var ss = SpreadsheetApp.getActiveSpreadsheet()
  var list = ss.getSheetByName("Тест") 
  var a = list.getRange(2, 1).getValue()
  list.getRange(3, 1).setValue(a)
  }

How can I move not just the text, but the link itself, keeping the name given in the cell? Preferably the easiest way

Answer 1

Maybe so?

function myFunction() {
  const ss = SpreadsheetApp.getActiveSpreadsheet();
  const sheet = ss.getSheetByName("Тест");
  
  const value = sheet.getRange(2, 1).getRichTextValue();
  
  sheet.getRange(3, 1).setRichTextValue(value);
}

---
Maxim Stoyanov (stomaks), developer of Google Apps Script .
g-apps-script.com
stomaks.me