LAST UPDATED
Edit a Status cell — the current time lands on that row, in whichever column you pick.
watch Status → stamp Updated
DATE, NOT TIME
Prefer a plain date? Use a {date} token — {date:eu}, {date:us} or {date:long}.
watch Status → stamp Logged · value "{date:eu}"
KEEP THE FIRST STAMP
"Don't overwrite" — edit the row again and the stamp holds. A true created-on.
watch Status → stamp Created · keep first
Status (edited twice)
Created
WHEN APPROVED
Tick a checkbox — the date it happened is recorded automatically.
watch Approved → stamp Approved on · only if checked
ONLY WHEN "DONE"
Only rows set to Done get stamped. Everything else is left alone.
watch Status → stamp Completed · only if "Done"
FLAG BIG ORDERS
Numeric conditions — only stamp rows above a threshold you set.
watch Amount → stamp Review · only if > 1000
PICK FROM A LIST
Match against several values at once — is one of "Shipped, Delivered, Closed".
watch Status → stamp Closed on · one of a list
BETWEEN TWO DATES
Range operators for dates and numbers — only stamp what falls between two bounds.
watch Due → stamp In window · between 1–15 Mar
WHO CHANGED IT
Every edit records the editor's email — useful on a shared sheet.
watch Status → stamp Edited by
CUSTOM REFERENCE
Build a value from fixed text plus tokens like {row}, {date} or {sheet}.
watch Item → stamp Ref · value "INV-{row}"
UNIQUE ID PER ROW
Drop a {uuid} token — or stamp a full UUID — for a tracking code that's never reused.
watch Item → stamp Tracking · value "{uuid}"
CLEAR WHEN EMPTIED
"Remove on deletion" — clear the Status and its stamp disappears too. Always in sync.
watch Status → stamp Updated · clear if emptied
EVERY SHEET AT ONCE
One rule, scope "all sheets" — every tab in the workbook is watched the same way.
watch Status · all sheets → stamp Updated
ONE FIXED CELL
Stamp a single cell, not a column — B1 always holds the latest edit, wherever it was.
watch Status → stamp cell B1