function checksetvalue(){
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName('EXAMPLE1');
var valueA1 = sheet.getRange('A7').getValue();
let shName = ss.getSheetName();
let cell = sheet.getActiveCell();
let col = cell.getColumn();
let row = cell.getRow();
if(shName === "EXAMPLE1" && valueA1 === true && col === 1 && row === 7 ) {
sheet.getRange('A8:A15').setValue('A');
//DEFINE MENU SHEET
//PART DROPDOWN - no need to keep installing the rule after the first time
/*
var partCell = sheet.getRange('A8:A15');
var partRange = sheet.getRange('A1:A6');
var partRule = SpreadsheetApp.newDataValidation().requireValueInRange(partRange).build();
partCell.setDataValidation(partRule);
*/
} else if( shName === "EXAMPLE1" && valueA1 === false && col === 1 && row === 7 ){
sheet.getRange('A8:A15').clearContent();
}
}