I was coding and i got stuck on this error. It keeps giving me that error “Exception: The parameters (String) don’t match the method signature for SpreadsheetApp.Range.setValues.” on the .setValues line which doesn’t make any sense to me.
Here is my code.
JavaScript
x
14
14
1
var finalPercentage5 = percantage5.map(x => [x]);
2
Logger.log(values.length)
3
Logger.log(finalPercentage5)
4
Logger.log(finalPercentage5[4][0])
5
for (var row=3; row<values.length; row++) {
6
if (M4.includes(values[row][0])) {
7
var i=0;
8
Logger.log(finalPercentage5[i][0])
9
ss.getRange(row+3, 28).setValues(finalPercentage5[i][0]);
10
i++;
11
12
}
13
}
14
I tried to debug it and it seem to me it is a number!
Here is a picture of the error:
Would really appreciate the help
If you any questions please let me know.
Thank you.
Advertisement
Answer
Try to change:
JavaScript
1
2
1
ss.getRange(row+3, 28).setValues(finalPercentage5[i][0]);
2
with:
JavaScript
1
2
1
ss.getRange(row+3, 28).setValue(finalPercentage5[i][0]);
2