Replace
var sheet = ss.getSheetByName('Sheet1');
by
var sheet = e.range.getSheet();
and replace
if(sheet.getName()=='Sheet1' && editedRange.getColumn()==7 && e.value=='Yes'){
by
if(['Sheet1', 'Sheet2'].indexOf(sheet.getName()) > -1 && editedRange.getColumn()==7 && e.value=='Yes'){
['Sheet1', 'Sheet2'].indexOf(sheet.getName())
will return 0
or 1
if sheet.getName()
returns 'Sheet1'
or 'Sheet2'
, respectively and -1
in any other case.
NOTE: You can remove var ss = SpreadsheetApp.getActiveSpreadsheet();
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…