# SOLVED: Help please: Scripts are triggering when the wrong sheet is edited
**URL:** https://community.glideapps.com/t/solved-help-please-scripts-are-triggering-when-the-wrong-sheet-is-edited/16577
**Category:** Ask for Help
**Created:** [September 30, 2020, 7:41pm UTC](https://community.glideapps.com/t/solved-help-please-scripts-are-triggering-when-the-wrong-sheet-is-edited/16577 "2020-09-30T19:41:03Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [September 30, 2020, 7:41pm UTC](https://community.glideapps.com/t/solved-help-please-scripts-are-triggering-when-the-wrong-sheet-is-edited/16577/1 "2020-09-30T19:41:03Z")
https://www.loom.com/embed/5ce3f5de89474ce7b01f7d65a1075efa
### “Code 2”/ “Code 3”
```auto
// The column you want to check if something is entered.
var COLUMNTOCHECK = 10;
// Sheet you are working on
var SHEETNAME = 'Bids';
function sendEmailApprovedBid() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getActiveSheet();
//checks that we're on the correct sheet.
if(sheet.getSheetName() == SHEETNAME) {
var selectedCell = ss.getActiveCell();
var selectedRow = selectedCell.getRow();
var dataRange = sheet.getRange(selectedRow, 1, 1, 20);
var data = dataRange.getValues();
//checks the column to ensure it is on the one we want to cause the date to appear.
if(selectedCell.getColumn() == COLUMNTOCHECK) {
for (var i = 0; i < data.length; ++i) {
var row = data[i];
var emailAddress = row[7]; // First column
if (emailAddress.match('@') === null){
continue; // skip this iteration of the loop and go to the next one
};
var message = row[16]; // Third column
var subject = 'Your Bid was ACCEPTED';
MailApp.sendEmail(emailAddress, subject, message, {name:'PRIZM', noReply: true});
SpreadsheetApp.flush();
}
}
}
}
```
* * *
* * *
* * *
### “Remove Request Email”
```auto
// The column you want to check if something is entered.
var COLUMNTOCHECK = 23;
// Sheet you are working on
var SHEETNAME = 'Requests';
function sendEmailRemovedRequest() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getActiveSheet();
//checks that we're on the correct sheet.
if(sheet.getSheetName() == SHEETNAME) {
var selectedCell = ss.getActiveCell();
var selectedRow = selectedCell.getRow();
var dataRange = sheet.getRange(selectedRow, 1, 1, 24);
var data = dataRange.getValues();
//checks the column to ensure it is on the one we want to cause the date to appear.
if(selectedCell.getColumn() == COLUMNTOCHECK) {
for (var i = 0; i < data.length; ++i) {
var row = data[i];
var emailAddress = row[7]; // First column
if (emailAddress.match('@') === null){
continue; // skip this iteration of the loop and go to the next one
};
var message = row[23]; // Third column
var subject = 'Your PRIZM Request was removed';
MailApp.sendEmail(emailAddress, subject, message, {name:'PRIZM', noReply: true});
SpreadsheetApp.flush();
}
}
}
}
```
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [September 30, 2020, 7:43pm UTC](https://community.glideapps.com/t/solved-help-please-scripts-are-triggering-when-the-wrong-sheet-is-edited/16577/2 "2020-09-30T19:43:39Z")
Nevermind…solved it. Had to change the SHEETNAME variable to something unique.
---
### Author:  [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)
#### Post date: [September 30, 2020, 7:49pm UTC](https://community.glideapps.com/t/solved-help-please-scripts-are-triggering-when-the-wrong-sheet-is-edited/16577/3 "2020-09-30T19:49:53Z")
I faced something similar right now, but glad you solved it.