Google Sheets has no built-in “last edited by” column. The information exists — every edit event carries the editor's identity — but only a script can read and record it. SmartStamp exposes it as a token, no code required.
Set it up
- Extensions → SmartStamp → Settings, tab Configure.
- Pick the sheet, row range, and the edit column to watch.
- Set Stamp target to the column that should show who made the edit.
-
Set Stamp value to
custom valueand insert the{email}token (or type it directly). - Save.
From then on, every qualifying edit stamps the editing user's address next to the row they touched — whether they typed into one cell or pasted a whole block of new rows.
Why the email is sometimes blank
A script's edit event only exposes the editor's email address when
the editor is signed in with an account in the same
Google Workspace domain as the file owner. A personal
@gmail.com account has no such domain, so Google
withholds the address — by design, for privacy, not because
anyone forgot to enable a setting. This limit applies to every
approach that reads the editor's identity, including a hand-written
onEdit script; it isn't specific to SmartStamp.
{email} stamp blank
— there is no add-on setting that changes this.
Combine it with other tokens
A custom stamp value can mix {email} with any other
token in one string:
{datetime:eu} by {email}— a combined “when and who” stamp in a single cell.{email}alone in its own column, next to a separate timestamp column.- Add a condition so only edits that actually matter (e.g. a status change to “Approved”) get an editor stamp at all.
Start tracking editors
One rule with the {email} token records who touched
each row — set up from a panel, no code.