Google Workspace Marketplace
Automatically stamp a timestamp, a custom value, or the editor's email when a watched column changes — no script needed.
Kehittäjä:
Tiedot päivitetty:16. marraskuuta 2026
Yhteensopiva seuraavien kanssa:
Ei arvosteluja
4
Yleiskatsaus
WHAT IT DOES

Stop typing "done" and today's date by hand. SmartStamp watches any column you choose and automatically writes a value into another column — or a fixed cell — the moment a qualifying edit happens. No Apps Script, no custom functions, no copy-pasting code from a forum post: you configure everything through a simple form, right inside the sheet, and it keeps running quietly in the background from then on — for everyone with edit access to that sheet, not just you.

STAMP VALUES & TOKENS

It's less a single-purpose "add a timestamp" tool than a small toolkit for turning edits into data. What gets written is up to you: the default timestamp, your own custom text, the email of whoever made the edit — handy for "reviewed by" or "approved by" columns without asking people to type their own name — or a UUID when you need a unique row ID that survives sorting and filtering. Custom text can weave in {row}, {date}, {email}, {sheet}, and {uuid} tokens, so "PO-{row}" becomes "PO-14" on row 14 without a formula in sight, and "reviewed on {date} by {email}" captures two facts in one stamp. When the plain {date} (yyyy-MM-dd) and {time} (24-hour) aren't the layout you want, {date:local} follows your spreadsheet's own locale, and {date:eu}, {date:us}, {date:long}, {time:us}, {datetime:eu}, and {datetime:us} force a specific layout.

CONDITIONS — WHEN IT FIRES

Most edits don't deserve a stamp, so conditions decide when one fires: compare numbers or dates, check whether a value falls between two bounds (or lands outside them), match it against a list of allowed values, test strings with contains/starts with/ends with and their opposites (case-sensitive or not, your call), or check whether a checkbox is ticked. Need something more specific, like a fixed order-number format? Match against a regular expression instead, with a one-click link to test the pattern before you save. And because one edit can trigger more than one range, a single change can stamp a timestamp in one column, the editor's email in another, and a status flag in a third — no script needed to keep them in sync. Pasting works the same way: drop in fifty rows at once and every qualifying row gets stamped in that same pass, not just the first cell.

WHO IT'S FOR

Built for anyone who currently tracks the "when" and "who" of a spreadsheet change by hand: ops and support teams logging ticket status flips, sales teams stamping a deal's move to "Closed", finance flagging invoices past a threshold, procurement generating PO numbers on approval, project teams marking due dates, HR timestamping onboarding steps — or any shared sheet where a fragile formula or someone's memory is currently doing this job and occasionally failing at it.

SETUP & BACKFILL

Setup lives entirely in a form inside the sheet: pick a sheet, a row range, the column to watch, done. Nothing to maintain afterward, and editing or deleting a range later is just as form-based — no digging through code. Setting this up on data you already have? Tick one box and it backfills every existing row that qualifies, not just edits from here on.

PRICING

There's a 14-day free trial with full access, no card required — you start it when you're ready (a button in the add-on, or the first time you save a setup beyond the free plan), so nothing counts down while you explore. After the trial, the free plan covers one range and 30 rows — enough to try it for real. Need more? Monthly, yearly, or lifetime plans unlock unlimited ranges and rows. Running this across a team? The Team plan covers the whole domain with one purchase and lets the buyer manage seats themselves. Visit base10addons.dev/smartstamp for full pricing, FAQ, and team-plan setup details.

Built by base:10 — practical Sheets add-ons for everyday spreadsheet work.
Lisätietoja
HinnatMaksuttomia ja maksullisia ominaisuuksia
Kehittäjä
Tuki
Tietosuojakäytäntö
Käyttöehdot
SmartStamp pyytää sinulta alla mainittuja lupia. Lue lisää
SmartStamp tarvitsee pääsyn Google-tilillesi
Tällä luvalla SmartStamp voi tehdä seuraavaa:
Tarkastele ja hallinnoi laskentataulukoita tällä sovelluksella
yhdistää ulkoiseen palveluun
Näytä ja julkaise kolmannen osapuolen internetsisältöä Google-sovellusten kehotteissa ja sivupalkeissa.
Salli tämän sovelluksen suorittaminen, kun et ole läsnä
nähdä Google-tilisi ensisijaisen sähköpostiosoitteen
nähdä henkilökohtaiset tietosi sekä kaikki sellaiset tiedot, jotka olet määrittänyt julkisiksi
yhdistää sinut Googlessa näkyviin henkilötietoihisi
Arvostelut
Kieli:
Lajitteluperuste:
Google ei todenna arvosteluja tai arvioita. Lue lisää arvosteluista
Ei kommentteja
Haku
Tyhjennä haku
Sulje haku
Google-sovellukset
Päävalikko