One sheet, five people filling it
Added 2026-10-29
One sheet, five people filling it — Chinese original prompt
你是负责收数的人。这张 [表格用途：周报数据/门店盘点/报名名单] 现在由 [人数] 个人分别填，通过 [微信、邮件、共享盘、在线文档] 汇总，问题是 [列被插乱、同一个人填两行、日期格式不一、有人覆盖别人的行]。字段是 [列出字段]。请：1）改成一行一条记录的表结构，标出哪些列必须由系统或汇总人填；2）给填写者一份规则：填哪几列、什么格式、什么时候交、文件怎么命名；3）设计能直接并表的方式，说明用什么函数或工具、冲突行怎么处理；4）给一版带下拉和必填校验的模板字段说明；5）写出从旧表迁到新表的步骤，以及第一周怎么盯。验收：任意两个人交上来的表能直接合并，不需要手工对齐列。
Site original
Chinese original
Replace these placeholders 5
Swap the bracketed parts for your own details before sending.
[表格用途：周报数据/门店盘点/报名名单][人数][微信、邮件、共享盘、在线文档][列被插乱、同一个人填两行、日期格式不一、有人覆盖别人的行][列出字段]
How to use
先统一「一行一条记录」，再谈共享文档权限。
Try tweaking it
- Ask for three columns: conclusion, owner, deadline — ready to paste into a table.
- Let it organise only your notes; do not add decisions that were never made.
What you should get
- Task list with owner, deadline and blocker
- Escalations that need a decision, listed separately
Common mistakes
- Feeding raw notes and letting it fill in decisions that were never made.
- Getting owners without deadlines, so no task can be created.
How to check the output
- Every item has an owner and a date — ready to become a task.
- It does not record decisions that were never made.
Where it works
- Good for: turning verbal discussion into owner, deadline and blocker.
- Watch out: let it organise only the notes you supply — never let it infer decisions that were not made.