A plain watched column stamps on every qualifying edit. Add a condition and SmartStamp only stamps when the new value passes a test you define — a number range, a text match, a date range, or a checkbox state. Everything else is ignored, no formula gymnastics required.
Set it up
- Extensions → SmartStamp → Settings, tab Configure.
- Pick the sheet, the row range, and the edit column to watch.
- Choose your stamp target and stamp value (a timestamp or custom text — see the token guides below).
-
Open the Condition section and pick a
type:
numeric,string,date, orcheckbox. - Pick an operator and enter the value(s) to compare against, then Save.
From then on, every edit to the watched column is checked against the condition first. Only a qualifying edit gets stamped — including a whole pasted or filled-down block, checked row by row.
The four condition types
| Type | Operators | Example |
|---|---|---|
| Numeric | = ≠ > < ≥ ≤ between / not between, is one of / is none of a list |
Stamp when the amount is > 500 |
| String | matches / doesn't match, contains / doesn't contain, starts with, ends with, matches regex / doesn't match regex, is one of / is none of a list — optional case-insensitive matching | Stamp when the status equals “Done” |
| Date | on, not on, after, before, on or after, on or before, between / not between | Stamp when the due date is before today's cutoff |
| Checkbox | is checked, is unchecked | Stamp when the review box gets ticked |
Matching with a regular expression
The string condition includes matches regex and doesn't match regex, checked against a standard regex engine. Use it for shapes a simple “contains” can't express — an order number in a fixed format, an email domain, a code that starts with a letter and ends in three digits. A Test your regex link opens regex101.com right from the condition row, and an invalid pattern is flagged before you save.
PO-2026-001, use matches regex with
^PO-\d{4}-\d{3}$.
Clear the stamp when it stops qualifying
By default a stamp, once written, stays — even if a later edit makes the condition false again. Turn on Delete stamp when the edit column no longer qualifies under Options and SmartStamp removes the stamp the moment an edit fails the condition, not only when the cell is emptied. Useful for a status that can flip back and forth (e.g. “Approved” → “Pending”) where the stamp should only exist while the condition currently holds.
Other options that combine with a condition
- Don't overwrite an existing stamp — keep the first qualifying stamp even if the row is edited again and still passes.
- Require a specific value in edit column — an extra exact-match gate on top of the condition.
- Also apply this to existing rows in the range now — run the condition against rows that already have data, so you don't have to re-edit each one by hand (see the backfill guide).
Add a condition to your first rule
Watch a column, pick a condition, choose what gets stamped — set up from a panel, no code.
See how it works →