NEW RECORD IDENTIFICATION · Workflow idea
A clear row identifier and a simple processed marker help a team separate new entries from work it has already handled. Review only unmarked rows, then record when each one has been processed so it is not mistaken for new next time.
01 / The starting point
Rows in a shared spreadsheet with a unique identifier and a field showing whether each row has been processed
“Find rows that have not yet been processed, make them available for the next task, and mark completed rows with a review timestamp.”
02 / The work
Helps a team keep track of which spreadsheet rows are new and which have already been handled.
Confirm that each entry has a unique value that lets the team distinguish it from other rows.
Identify entries that do not yet show that someone has handled them.
Make the unprocessed entries easy for the responsible person to review or act on.
Record when each row was handled so the team can understand its status later.
Confirm that completed rows are no longer treated as new and investigate repeated or unclear identifiers.
03 / The result
A clear set of newly added rows, with completed entries marked so the team can distinguish them during a later review.
Data · Example outcome
A clear set of newly added rows, with completed entries marked so the team can distinguish them during a later review.
Each row needs a stable unique identifier and a clear processed field. Review the marker before relying on it, and resolve rows that appear duplicated or were only partly handled.
04 / Make it yours
A few choices shape the work around your team.
Identify the shared list, the unique row identifier, and the field used to show processing status.
Define when a row is considered complete and when it should remain available for follow-up.
Name who reviews or handles unprocessed entries and who resolves duplicates or partial work.
Check that new entries are surfaced, completed rows are skipped, and timestamps are understandable.