I've been trying to figure this one out and I'm a bit lost...
This is what I have so far:
function deleteCheckedBoxes() {
const sheet = SpreadsheetApp.getActiveSheet();
const activeRange = sheet.getActiveRange();
const activeRow = activeRange.getRow();
const activeColumn = activeRange.getColumn();
let rangeUpdatedValue = activeRange.getValue();
if(activeColumn == 5 && rangeUpdatedValue == true){
sheet.deleteRow(activeRow);
};
}
How can I get it to clear the row instead of deleting it?
I have tried clearContent & ClearContents, but it doesn't seem to work
Any help would be greatly appreciated!
When your showing script is modified, how about the following modification?
sheet.deleteRow(activeRow);
sheet.getRange(activeRow, 1, 1, sheet.getLastColumn()).clearContent();
clearContent(), the checkbox is unchecked.