Task and my work.
The client needed to track product items, delays and open questions in Google Sheets. Completed records had to go to an archive and be restorable back to work.
- Designed four working sheets: orders, tasks, dashboard and archive.
- Set up autofill for date, quantity and initial status when those fields are still empty.
- Added flags for items not purchased after seven days and questions unanswered after two days.
- Built archiving and restoring that keeps the original date and fields.
- Adjusted fields and formulas after feedback. The project was accepted in July; the changes were verified in August 2026.
Key decisions.
Restoring from the archive keeps the item's age.
A record comes back with its original date, status and delay reason. Autofill only touches fields that are still empty.
The script checks headers before touching columns.
When a new field is added, the script verifies the column layout before writing. After changing the structure, I separately re-tested autofill, formulas, archiving and restoring.
How it works.
- Add an item
An employee enters the product and working data. Empty service fields fill in automatically.
- Track status and delays
The employee updates the status. Formulas highlight overdue items and questions that need an answer.
- Move a record to the archive
The employee marks the row. The automation copies its fields and clears the original row.
- Bring a record back
Restoring keeps the original date, status and data. The item's age still counts from when it was first added.
Implementation and example.
An interactive web demo with fictional items. It shows the status, deadline and archive rules. The client's real system runs in Google Sheets; its data is not used here.
Try the status, archive and restore.
An interactive demo with fictional items. Demo date: September 23, 2026. The real system runs in Google Sheets. Changes here last until you reload the page.
Change the lamp's status or move the notebook to the archive. Then bring it back.
An employee changes the status. Setting "Shipped" does not archive the item on its own. Restoring keeps the original date and status.
Project result.
Item status, open questions and a summary are in one spreadsheet. Records can be archived and brought back. Purchasing decisions and keeping statuses current stay with the team.
Technologies and implementation details
Google Sheets, formulas and Apps Script. The automation fills empty service fields and moves records. When a new field is added, the script checks the headers and stops if the columns are not where it expects them. In the original system, control is visible in the sheet and on the dashboard; there are no external notifications.
Let's discuss your task.
We can start with the sheet structure, autofill fields, statuses, deadline control or the archive. We will pick one recurring scenario and test it on a few examples.
Discuss a spreadsheet tracker ↗︎