javascript - How to build an array, "Incorrect range height" error -


i've been struggling code quite while now, i'm trying information a single column 1 sheet , set notes in sheet example. content c2 on "sheet1" should go note on "f2" on sheet "report" note (a note shift+f2 not comment ctrl+alt+m).

so far have this:

function insertphonenumbers() {     //i'm still working on have not been able make work//     //ideally put phone numbers comment's in needed cases//     var ss = spreadsheetapp.getactivespreadsheet();     var targetsheet = ss.getsheetbyname("report");     var sourcesheet = ss.getsheetbyname("sheet1");     var nrange = sourcesheet.getrange(2, 3, sourcesheet.getlastrow(), 1)     var sourcenotes = [nrange.getvalue()]     var notes = targetsheet.getrange(2, 6, sourcesheet.getlastrow(),1)     notes.setnotes([sourcenotes]); } 

but giving me error while debugging "incorrect range height, 1 should 75" range 73 rows deep don't know do.

try code below source range , add them note in target sheet:

function insertphonenumbers() {   var ss = spreadsheetapp.getactivespreadsheet();  var targetsheet = ss.getsheetbyname("cancel");  var sourcesheet = ss.getsheetbyname("regis");  var nrange = sourcesheet.getrange(2, 3, sourcesheet.getlastrow(), 1)  var sourcenotes = nrange.getvalues()  //logger.log(sourcenotes);  var notes = targetsheet.getrange(2, 6, sourcesheet.getlastrow(),1)  notes.setnotes(sourcenotes);  } 

let me know if not looking for.


Comments