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
Post a Comment