Productivity & PKM
Webapps Stack Exchange · 2024-12-17
Sort a Google Sheets range by each row's last-edit time — without a date column
表格没有日期列，想在 Google Sheets 按每行的最后编辑时间排序
At a glance · 30-second read
- WhoWebapps Stack Exchange · 2024-12-17 · 1 upvotes
- The askSort a Google Sheets range by each row's last-edit time — without a date column
- The openingA Sheets add-on: onEdit-triggered row timestamps plus one-click sort-by-recency. Free, with a team tier.
What was actually said
“My project-tracking table updates constantly but has no date column (only completion dates). Can I sort the range by each row's last edit time?”
— Webapps Stack Exchange · 2024-12-17 · webapps.stackexchange.com/questions/180097/is-there-…
Background and pain
The pain
You can't see which rows just changed: Sheets hides row-level edit times, so teams hand-maintain date columns and forget.
A buildable angle
The opening
A Sheets add-on: onEdit-triggered row timestamps plus one-click sort-by-recency. Free, with a team tier.
How to validate it
- Read the whole thread and note the recurring scenarios — repetition is the density of the need.
- Search existing tools around "google sheets / collaboration" and check which single step they actually cover.
- Put up a one-line landing page, share it back to Webapps Stack Exchange, and see whether anyone asks about pricing.
Existing options
手动日期列Zapier 方案
More threads on this pain
- Why is there no good open-source LMS for people starting a teaching business?Hacker News · 2021-11-19
- Good ways to capture institutional knowledge inside a companyHacker News · 2020-03-01
- 88 replies: how do you actually manage tasks inside Obsidian?Obsidian Forum · 2020-05-30
- Syncing notes to mobile: official sync and iCloud both have holesObsidian Forum · 2025-03-20
- A huge language-learning resource list is unusable in NotionStack Exchange · 2026-02-23