Alert when Checkbox Column gets Unchecked
I have a formula column that gets checked or unchecked depending on some other things in the sheet.
An alert goes out when this gets unchecked (and when rows get changed, not added) on an hourly basis.
We recently got an alert saying that a row got unchecked but it makes no sense. I checked the cell history, and it was never checked in the first place. I would understand if someone made a quick mistake and deleted it but the alert is set to hourly, not immediately. That row did just get added, though.
My question is: did this alert go off because a new row got added? And a new checkbox was then created, starting off unchecked, and triggered the alert?
Would it help to put this column as "not blank" as a condition for the alert? Or would that cancel it out from the trigger?