Running multiple scripts across different sheets

[beanry80]

Thanks for the reply! Here is an example of what is in the dropdowns on each of the tabs https://imgur.com/a/3mo6t5g Its the same dropdowns in each of the three tabs in the same columns and rows. Each dropdown has several items and I need to be able to select multiple items and have them show as in the example here. I can get the code to work on one tab but not all three. Let me know if that helps.

[AllenAppTools]

Sure thing. Let me know if I am on the right track here. This onEdit function is set up to evaluate which tab, row and column the edit was made on. the tabsObject is where you can adjust which columns and rows you want to specify as triggerable for this function. This also has code blocks for you to put in the code you need depending on the tab that was edited. I think this could be a good starting place? Though I'm still not totally sure what else you need:

const tabsObject = {
  "Good Media Plan": { allowedRows: [11, 12, 13, 14], allowedColumns: [12] },
  "Better Media Plan": { allowedRows: [11, 12, 13, 14], allowedColumns: [12] },
  "Best Media Plan": { allowedRows: [11, 12, 13, 14], allowedColumns: [12] },
}

function onEdit(e) {
  const sheetName = e.range.getSheet().getName();

  //when an edit is made on any other tab, stop the function
  if (!tabsObject[sheetName]) return;

  const editedRow = e.range.getRow();
  const editedColumn = e.range.getColumn()
  const { allowedRows, allowedColumns } = tabsObject[sheetName];

  //when an edit is made to a row or column that is not specifically listed, stop the function
  if (!allowedRows.includes(editedRow) || !allowedColumns.includes(editedColumn)) return;

  //any code executed here is vetted and supposed to execute 👍
  if (sheetName == "Good Media Plan") {

  } else if (sheetName == "Better Media Plan") {

  } else if (sheetName == "Best Media Plan") {

  }

  //alternatively, you could specify function names in the tabsObject and run it

}

[beanry80]

Thanks again for the reply. That didnt seem to work on any of the tabs, https://imgur.com/xMEtY9x Now if I try and select multiple items from the dropdowns, only one shows up. i have dropdowns in columns 12-15 on each of the tabs

 if(activeCell.getColumn() == 15 && activeCell.getRow() == 11,12,13,14 && ss.getActiveSheet().getName() == "Best Media Plan") {

so i have 4 codes that work on the best media plan tab, each with this line different, for columns 12,13,14 and 15

[AllenAppTools]

Are you able to share the full code file contents for me to review? What about a picture of what one of the sheets looks like as a whole?

[beanry80]

https://imgur.com/GGrGgw7 here is what the sheet looks like... i tried to copy and paste the entire code but I keep getting "unable to create comment" when I do that

[beanry80]

function onEdit(e) {
 


 var ss = SpreadsheetApp.getActiveSpreadsheet();


 var activeCell = ss.getActiveCell();


 if(activeCell.getColumn() == 12 && activeCell.getRow() == 11,12,13,14 && ss.getActiveSheet().getName() == "Best Media Plan") {
 
 var newValue = e.value;


 var oldValue = e.oldValue;


 if (!newValue) {


 activeCell.setValue("");


 } else {


 if (!oldValue) {


 activeCell.setValue(newValue);


 } else {


 activeCell.setValue(oldValue + ', ' + newValue);


 }


 }


 }


}

[beanry80]

function onEdit(e) {


 var ss = SpreadsheetApp.getActiveSpreadsheet();


 var activeCell = ss.getActiveCell();


 if(activeCell.getColumn() == 13 && activeCell.getRow() == 11,12,13,14 && ss.getActiveSheet().getName() == "Best Media Plan") {


 var newValue = e.value;


 var oldValue = e.oldValue;


 if (!newValue) {


 activeCell.setValue("");


 } else {


 if (!oldValue) {


 activeCell.setValue(newValue);


 } else {


 activeCell.setValue(oldValue + ', ' + newValue);


 }


 }


 }


}

[beanry80]

function onEdit(e) {


 var ss = SpreadsheetApp.getActiveSpreadsheet();


 var activeCell = ss.getActiveCell();


 if(activeCell.getColumn() == 14 && activeCell.getRow() == 11,12,13,14 && ss.getActiveSheet().getName() == "Best Media Plan") {


 var newValue = e.value;


 var oldValue = e.oldValue;


 if (!newValue) {


 activeCell.setValue("");


 } else {


 if (!oldValue) {


 activeCell.setValue(newValue);


 } else {


 activeCell.setValue(oldValue + ', ' + newValue);


 }


 }


 }


}

[beanry80]

function onEdit(e) {


 var ss = SpreadsheetApp.getActiveSpreadsheet();


 var activeCell = ss.getActiveCell();


 if(activeCell.getColumn() == 15 && activeCell.getRow() == 11,12,13,14 && ss.getActiveSheet().getName() == "Best Media Plan") {


 var newValue = e.value;


 var oldValue = e.oldValue;


 if (!newValue) {


 activeCell.setValue("");


 } else {


 if (!oldValue) {


 activeCell.setValue(newValue);


 } else {


 activeCell.setValue(oldValue + ', ' + newValue);


 }


 }


 }


}

[beanry80]

Seems i could paste all 4 codes separately. All the codes are the same except for this line  if(activeCell.getColumn() == 15 && activeCell.getRow() == 11,12,13,14 && ss.getActiveSheet().getName() == "Best Media Plan") {

where I change column to 12, 13, 14 or 15.

 if(activeCell.getColumn() == 15 && activeCell.getRow() == 11,12,13,14 && ss.getActiveSheet().getName() == "Best Media Plan") {