There are two columns N and O.

enter image description here

When any cell in column N is filled the adjoining cell in column O needs to filled with "Yes" if not it stays empty.

This is the script I'm using.

var s = SpreadsheetApp.getActiveSheet();
    if( s.getName() == "Sheet 1" ) 
        var r = s.getActiveCell();
           if( r.getColumn() == 14 && r.getValue() == '') 
              var nextCell = r.offset(0, 2);

How can I change/modify the above script to show if when a cell is filled in a particular column then the adjoining cell shows as "Yes"

Or simply put translate this formula into a script


Without using it in this form

var cell = sheet.getRange("C2:C1000");

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.