I have been out of coding for a while and have forgotten much. I am attempting to read data from a selection of cells from one page and then write it to another section if it meets the criteria. Both the original section and the new section are utilizing the same number of cells, but when I attempt to write the information in the new section the output is not as desired. I have attempted:
function testertester(){
var ss = SpreadsheetApp.getActive();
var consume = ss.getRange('Consumables').getValues();
var data = consume[0];
Logger.log(data);
ss.getRange('NewSheet!B3:Y3').setValue(data);
}
The above puts the value for [0][0] in every cell in the range. I have also attempted:
function testertester(){
var ss = SpreadsheetApp.getActive();
var consume = ss.getRange('Consumables').getValues();
var data = consume[0];
Logger.log(data);
ss.getRange('NewSheet!B3:Y3').setValues(data);
}
This results in "Exception: The parameters (number[]) don't match the method signature for SpreadsheetApp.Range.setValues."
Can someone please explain what I am doing wrong.