Triggering function only when specific sheet is edited

Question

I have a google sheet that I want to add a time stamp every time a cell was updated. I have the basic code down:

function onEdit() { 
    var s = SpreadsheetApp.getActiveSheet(); 
    var c = s.getActiveCell();  
    var cell1 = 13 
    if(c.getColumn() != cell1 ) { 
        var row = c.getRow();  
        var time = new Date(); 
        time = Utilities.formatDate(new Date(), "EST", "MM-dd-yyyy HH:mm:ss");
        SpreadsheetApp.getActiveSheet().getRange(row,cell1).setValue(time); 
    };
};

But I want to only trigger it on 1 sheet called "VariableMaster" so I tried:

if(c.getColumn() != cell1 && s == "VariableMaster") {....

I also tried adding another if statement below that

 if(c.getColumn() != cell1 ) { 
      if(s.getActiveSheet == "VariableMaster"){...

Both attempts breaks the function and it doesn't add the time stamp to any sheet. Thanks!

Serge insas · Accepted Answer · 2014-09-02 05:10:03Z

2

The parameter you want to check is the sheet name so you have to compare the sheet Name.

Use if(c.getColumn() != cell1 && s.getName() == "VariableMaster") {....

answered Sep 2, 2014 at 5:10

Serge insas

46.9k7 gold badges113 silver badges135 bronze badges

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

Collectives™ on Stack Overflow

Triggering function only when specific sheet is edited

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related