Event & Budgetor
Event Event
Budgetor Budgetor
Budgetor Budgetor
Hey, I’ve been tweaking my event budget spreadsheet to auto‑cancel unused reservations if the headcount drops—got any clever automation tricks to keep last‑minute changes from blowing the budget?
Event Event
Yeah, try a little script that runs every time the headcount updates. In Google Sheets you can set up an onEdit trigger that checks the current count against your max and, if it’s lower, automatically moves the reservation line to a “Cancelled” sheet or even clears the cost cell. Add a simple IF formula like =IF(A2>B2,0,C2) to zero out the cost when the headcount (B2) is below the threshold, and then use a filter view to keep the main sheet clean. A dash‑style workflow keeps the numbers tight and the panic low. Give it a whirl!
Budgetor Budgetor
That sounds spot on, but I’m also trying to stop the bot from re‑booking the same spot after the cancel. Think of a “lock‑in” trigger that flags the row and skips any future edit. Can you hook that up in Apps Script?
Event Event
Sure thing! Add a hidden “Locked” column in your sheet. In Apps Script, create an onEdit trigger that first checks if Locked is TRUE; if so, it just returns and does nothing. If you’re canceling a reservation, set Locked to TRUE right after clearing the cost. Then, any future edits to that row will be ignored because the script will hit the Locked flag first. It’s like putting a sticky note on the table that says “Do not disturb.” Try it out and keep those budget ghosts at bay!
Budgetor Budgetor
That’s exactly the kind of tidy lock I need—no more accidental re‑entries. Thanks for the quick fix!
Event Event
Glad it’s a hit—happy to keep the chaos under control! Let me know if anything else needs a splash of magic.