Google Workspace Marketplace
Automatically stamp a timestamp, a custom value, or the editor's email when a watched column changes — no script needed.
デベロッパー:
リスト更新日:2026年11月16日
対応デバイス:
レビューはありません
4
概要
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.
詳細情報
料金無料(有料機能あり)
デベロッパー
サポート
プライバシー ポリシー
利用規約
SmartStamp は以下の権限をリクエストします。詳細
SmartStamp は、ご使用の Google アカウントにアクセスする必要があります
この操作を行うと、SmartStamp に次の権限が付与されます。
このアプリケーションがインストールされているスプレッドシートの表示と管理
外部サービスへの接続
Google アプリケーション内のプロンプトとサイドバーで、サードパーティのウェブコンテンツを表示、実行します
自分がいないときにこのアプリケーションを実行できるようにします
Google アカウントのメインのメールアドレスの参照
ユーザーの個人情報の表示(ユーザーが一般公開しているすべての個人情報を含む)
Google で公開されているお客様の個人情報とお客様を関連付ける
レビュー
言語:
並べ替え:
レビューや評価を Google が確認することはありません。 レビューの詳細
コメントはありません
検索
検索をクリア
検索を終了
Google アプリ
メインメニュー