I’m using Apps Script to make a custom function that sets the note of a specific cell in a spreadsheet, but I’m getting the error “Exception: You do not have permission to call setNote,” even though the cell that’s being targeted is the same cell that’s calling the function. My code is:

var ss = SpreadsheetApp.getActive(); 
var sh = ss.getSheetByName("Sheet1"); 

function setCellNote(targRow, targCol, text, display) { 
  var cell = sh.getRange(targRow, targCol);
  cell.setNote(text); 
  return display;
}

and the call in the sheet is in cell A2 as =setCellNote(ROW(A2),COLUMN(A2),"test", "done")

I’ve tried using A1 notation, but I had to have the cell reference in quotes (meaning =setCellNote("A2"),...), and I need this to work across many cells, so the actual cell reference needs to automatically change as I copy the formula across many cells.