I am using Google sheets and have a cell that has data validation and I am putting check boxes (I4:I) for people when items are received, they need to be changed to "False" when the Data Validation cell (C2) is changed.
I'm new at this, but this is what I have, but I am getting a syntax error on Line 5.
function onEdit(e){
if(e.range.getC2Notation() == 'C2' &&
e.range.getSheet().getName() == 'Outbound Parts'
)
e.source.getRange('I4:I'),"FALSE"
}
Any help would be appreciated.