Frequently Asked Questions

It writes a timestamp, a custom value you choose, the editing user's email, or a UUID into a cell whenever you edit a watched column, based on ranges and conditions you configure per sheet.

Yes — a custom value can mix fixed text with these tokens, expanded when the stamp is written:

• {row} — the row number of the edit (stamp column mode) or of the fixed stamp cell (stamp cell mode).
• {date} — today's date as yyyy-MM-dd.
• {email} — the editing user's email.
• {sheet} — the name of the sheet the edit happened on. Most useful on an "all sheets" range, where it's the only way to tell which sheet a given stamp came from.
• {uuid} — a freshly generated UUID.

Example: PO-{row} stamps PO-14 on row 14. Tokens are embedded in plain text, not a live formula — they're fixed at the moment of the edit and won't update afterward.

Stamp column writes the timestamp on the same row you just edited (e.g. "last updated" per row). Stamp cell always writes to one fixed cell, regardless of which row in the range you edited — useful for a single "sheet last touched" indicator.

• Numeric — compare with =, ≠, >, <, ≥, ≤, or between/not between two values — bounds excluded, so a value exactly on a bound stamps for "not between" but not for "between", or a comma-separated list with "is one of"/"is none of" (e.g. "5, 10, 15").
• String — matches, doesn't match, contains, doesn't contain, starts with, ends with, matches regex, or doesn't match regex, or a comma-separated list with "is one of"/"is none of" — for the regex options, a "Test your regex" link opens regex101.com to help build and check the pattern. Case-sensitive by default, with an option to ignore case. Values in the list can't contain a literal comma.
• Date — require on, not on, before, after, on-or-before, on-or-after, or between/not between two dates — boundary days excluded, so a date exactly on a bound stamps for "not between" but not for "between" — compared by calendar day (time of day is ignored). The edit column must contain a real date-formatted cell, not plain text that merely looks like a date.
• Checkbox — require the box to be checked or unchecked. No value to type — pick "is checked" or "is unchecked" and that's it.

If you don't need a condition, every edit in range stamps.

Yes. Pasting a block of values or dragging fill-down over several rows stamps every qualifying row in the edited range, not just single-cell edits — conditions are checked per row.

By design, on Google's side. SmartStamp only reacts to a real edit — a person (with the add-on installed) typing, pasting, or filling in a cell. A formula recalculating, or another script writing a value with something like Range.setValue(), never fires Google Sheets' edit trigger at all, for any add-on, not just this one.

It's not lost, just queued. Google processes each edit through its trigger system one run at a time, not simultaneously. If you type or paste values very quickly in succession, the stamps can lag a few seconds behind before catching up. No data is ever lost — the stamp always arrives.

No. Once you install and configure SmartStamp on a shared sheet, it stamps edits made by anyone with edit access to that sheet — colleagues don't need to install it themselves. One caveat: the "current user's email" stamp value reliably captures the actual editor only when they're in the same Google Workspace domain as whoever installed SmartStamp (or they've chosen to share their email in their Google Account settings). Outside that, it falls back to your own email instead of theirs.

Your settings won't follow the shift. Edit and stamp columns are stored as fixed column numbers, so inserting or deleting a column in between shifts everything after it — your configuration will then point at the wrong column. After restructuring your sheet, open SmartStamp's settings and double-check (or re-select) your edit and stamp columns.

Yes. Different edit columns can each stamp into the same destination column (or cell) — every edit column fires its own edit independently, so e.g. editing column B or column C can both stamp column E.

The one thing that's blocked is two ranges watching the same edit column, on the same sheet, stamping the same destination on overlapping rows — only one of those would ever actually fire, so SmartStamp rejects that combination when you save.

Open Settings from the add-on menu, go to the "Saved settings" tab, and use the Edit or Delete button on the range you want to change.

Found at the bottom of the "Saved settings" tab, it deletes all saved ranges for this spreadsheet at once (after a confirmation) — use Delete on an individual range instead if you only want to remove one.

It only removes the add-on's configuration — timestamps or values already written into cells stay exactly as they are.

Open the Account & Support tab and click "Manage subscription" — this opens Stripe's self-serve billing portal. See the pricing FAQ for details.

No. Uninstalling only removes the add-on from your account — it doesn't cancel any active subscription or free up a team seat. Monthly and yearly plans keep renewing until you cancel them yourself via the Account & Support tab's "Manage subscription" (or ask your domain admin to remove your seat for team licenses).

New installs get a free 14-day trial automatically, no credit card required. After that you drop to the free plan: up to 2 ranges, 50 rows total across all of them — enough to try SmartStamp on a small sheet indefinitely. An active paid plan removes those limits — check your status any time in the Account & Support tab.

If you had more than the free plan allows (e.g. an active subscription lapsed), your oldest ranges keep stamping up to the free plan's budget — newer ones stop immediately, rather than waiting until you next open Settings. Values already stamped stay exactly as they are.

Yes. Individual licenses are per user — installing the add-on domain-wide from the Google Workspace Marketplace does not give every domain user full access on its own.

If you want to cover a whole team or organization, see the team pricing — €10.99/seat/yr, minimum 5 seats (€54.95/yr total to start), billed yearly. Or contact us first if you have questions.

For domain admins, here's the full process:

1. Purchase a team license first — this links a number of seats to your domain.
2. Then install the add-on domain-wide from the Google Workspace Marketplace admin console — this gives people access to open the add-on itself.
3. Seats are assigned automatically: the first people on your domain to open the add-on each claim a seat until they're all used. As the buyer, you can also pre-assign or remove specific teammates via "Manage team seats" in the Account & Support tab.

⚠ Order matters: this also applies if you roll out the add-on domain-wide from the admin console before buying seats. Anyone who opens it first starts their own individual 14-day trial instead — and won't be picked up by the team license until that trial runs out. Buy the seats first, then roll out the install.

Tip: the email address you use on the Stripe payment page becomes the domain admin — make sure it matches the Google account you'll use to manage seats afterward via "Manage team seats".

Tip: to control who even sees the add-on in step 2, install it for specific organizational units or groups instead of the whole domain — pick this in the Google Admin console when installing (Apps → Google Workspace Marketplace apps → select the app → Install for specific OUs/groups).

Yes — on the Account & Support tab, click Give up my seat. No admin involvement needed. Getting a seat back afterwards does require the domain admin to re-add you via "Manage team seats" — it's not automatic just by reopening the add-on again.

Use the feedback form in the Account & Support tab (Settings → Account & Support) — every message reaches support directly. You can also email us.