Each guide shows the no-add-on approaches first — a formula, an Apps Script trigger — then how SmartStamp does the same thing from a panel, with the edge cases handled.
Add a timestamp when a cell changes
Why =NOW() never stays put, and three ways to freeze the
moment of an edit: a self-referencing formula with iterative
calculation, an onEdit Apps Script trigger, and
SmartStamp. Includes the limits of each.
Stamp a row only when a condition is met
Number ranges, text matches (including regex), date ranges, and checkboxes as trigger conditions — and how to clear a stamp again when an edit stops qualifying.
Auto-generate sequential PO / order / ticket numbers
The {row} and {uuid} tokens for a
self-filling order number like PO-2026-014, and where
a row-based counter stops being safe to rely on.
Track who edited a row
Stamp the editing user's email with the {email} token,
and the Google Workspace domain limit that applies to any
onEdit-based approach.
Backfill timestamps for existing rows
Apply a brand-new rule to data you already have, not just future edits — the “Also apply this to existing rows now” option explained.
Paste multiple rows and stamp them all at once
How SmartStamp handles a pasted or filled-down block of rows in one pass — every qualifying row stamped, clamped to your configured range.
Set up SmartStamp for your whole team
How the team plan works for a Google Workspace domain: buying seats, inviting teammates, and self-service seat management.