How to get the correct range to set the value to a cell?
The following code does what is required function doTest() { SpreadsheetApp.getActiveSheet().getRange(‘F2’).setValue(‘Hello’); }
The following code does what is required function doTest() { SpreadsheetApp.getActiveSheet().getRange(‘F2’).setValue(‘Hello’); }