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 앱
기본 메뉴