Alert when Checkbox Column gets Unchecked

SYSPK
SYSPK ✭✭✭✭✭✭
edited 06/21/21 in Smartsheet Basics

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?


Thank you

Best Answer

  • SYSPK
    SYSPK ✭✭✭✭✭✭
    Answer βœ“

    I've come up with a workaround :)

    I'll get another cell changed if the rate is ever chosen as 2. Maybe it can record the date. This cell will stay untouched no matter what happens later.

    Then when this cell isn't blank AND when the checkbox gets unchecked, then we will know it went from 2 to something else.

    @Paul Newcome I'm still open to smoother ideas though.

    Thanks for your help

Answers