I have a spreadsheet which values comes from an importRange function, the thing is that the getRange function is not fetching the right values, regardless the ROW, COLUMN selected, it returns the word “info” all the time except for Row Column 1,1 (or A1), it returns #Error.
it is weird right? I dunno what am I doing wrong, hope you can help, it is driving me crazy, here is my test function
function TestFunction()
{
var ss = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("OTs");
Logger.log(ss.getRange(14,5).getValue().toString());
}
and in the image is the data in that spreadsheet,
here is the results in the console: