Automatically write a timestamp, your own custom value, or the editing user's email into a cell whenever you edit a watched column. Set it up once per sheet, it runs itself from then on.
Stamp the current date/time, any fixed text you choose, or the email of whoever made the edit
Per-row "last updated" tracking, or a single fixed "sheet last touched" cell
Only stamp when the edited value matches a condition you define
Multi-row edits stamp every qualifying row, not just single cells
Configure as many watched ranges as you need, each with its own rules
A plain =NOW() recalculates every time the sheet does, so it never records when something happened. SmartStamp writes the value once, at the moment of the edit, and leaves it alone.
You could freeze a timestamp with an onEdit script, but then every file needs its own copy that you have to keep working. Here you set up rules in a dialog, and updates arrive automatically.
Turn on “Don't overwrite an existing stamp” and the first stamp survives later edits. You can also have a stamp cleared when its row stops qualifying.
Fire a stamp when a number, text, date or checkbox meets your rule: above a threshold, between two dates, contains a word, or matches a regex.
Paste or fill down across many rows and every qualifying row gets its stamp in one pass. Backfill stamps the rows that already exist, without editing each one again.
Set it up once on the sheet. Everyone with edit access triggers the stamps, with nothing to install on their side.
14-day free trial on all plans. No credit card required.