Script has an error while running the code

Question

I am new to Google Sheet App Script and trying to to create a IF condition with it but receiving an error.

I want to populate This "Right" result in Cell AO3

Your help will be appreciated

function myFunction() {

 var sheet = SpreadsheetApp.getActive().getSheetByName('DATA')
 var ss = sheet.getRange()

   if(ss.getRange("i3").getValue()!='' 
   && 
   ss.getRange("h3").getValue()!='')
   
   {

console.log("Right!");
  
}
}

If you get an error, always post the error message. It's the key to knowing what's wrong. — Thomas
– Thomas, Commented Jan 28, 2021 at 16:35
You didn't pass any parameters when calling getRange() (see the red squiggly line). It requires a row and column. — Thomas
– Thomas, Commented Jan 28, 2021 at 16:40
How to make a code with this var range = ss.getRange(3, 35); @Thomas — user14807564
– user14807564, Commented Jan 28, 2021 at 16:48
@Learning there are 4 ways of requesting a range. All of them are in this page: developers.google.com/apps-script/reference/spreadsheet/… . There are examples for each of them so you can play around. — Marios
– Marios, Commented Jan 28, 2021 at 16:55

Marios · Accepted Answer · 2021-01-28 16:40:02Z

1

Issues:

You didn't pass any parameters in the getRange() method.
Even if you did the first part correctly, in your code, ss is already a range object because you already used getRange(..). Therefore you can't use getRange(..).getRange('i3') twice.

Solution:

function myFunction() {
 var ss = SpreadsheetApp.getActive().getSheetByName('DATA');
 if(ss.getRange('i3').getValue()!='' && ss.getRange("h3").getValue()!='') { 
      console.log("Right!");
     ss.getRange('ao3').setValue("Right!");
  }
}

edited Jan 28, 2021 at 16:40

answered Jan 28, 2021 at 16:38

Marios

27.5k9 gold badges40 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

user14807564 Over a year ago

Thank you so much @Marios for the solution but how to paste console.log result in range AO3

Marios Over a year ago

@Learning answer updated. The value will be pasted only if it passes the if condition.

user14807564 Over a year ago

Yes @Marios well noted.

Collectives™ on Stack Overflow

Script has an error while running the code

1 Answer 1

Issues:

Solution:

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Issues:

Solution:

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related