Im just getting started with google scripts and Im trying to create a very basic script to help me understand the fundamentals.
The script would look for the number 5 in cell E2 and then return a value of 5 if true or 10 if false. The issue Im running into is that if I enter a "5" on E2 I do not get a "5" on E4. it always says "10" on E4.
I have tried changing the operator to = and === as well as putting quotes ("5") around the 5 to look for text rather than a number and cant get it to work.
function onEdit()
{
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var cell = sheet.getRange(2,5);
var cell2 = sheet.getRange(4,5);
if (cell == 5) {cell2.setValue(5);}
else {cell2.setValue(10);}
}
Aucun commentaire:
Enregistrer un commentaire