[This Script]1 seems to be exactly what I want. Yet, it doesn't "Fire" when the reference cell is edited. That is, the target cell is not cleared. Just nothing happens upon editing the referenced cell. No error messages.
My script has been edited it to reflect specific named cells and the "Sheet 1" as the actual sheet's name i.e.'License':
function OnEdit(e) {
if(e.range.getA1Notation() == 'RowNumber' &&
e.range.getSheet().getName() == 'License'
)
e.source.getRange('InputPicHere').clear()
}
Any clues why it doesn't run?