# Combine tasks into a source-linked work list Canonical page: https://agents.paretoid.com/workflows/combine-tasks-into-a-source-linked-work-list/ Category: Operations & Reporting Practice relevance: cross-practice. A general operational method. Review the stated tool and jurisdiction limits before use. Jurisdiction/provider scope: Bring approved task exports together while keeping conflicting owners, dates, and completion states visible. Status: Proposed / not tested. The public source describes the problem. Documentation supports only the stated method components; no result from this recipe has been verified. Verification: Source methods and reported problems have been reviewed. We have not run the adapted workflow. The sample below describes expected behavior on synthetic data, not a customer result. ## The problem Bring approved task exports together while keeping conflicting owners, dates, and completion states visible. Why it matters: Tasks spread across notes and systems can have conflicting owners or completion states. A source-linked register gives the team one review surface while preserving the original instructions and unresolved differences. ## Sources and evidence - pain: [Pain evidence: Help organizing my to-do list](https://www.reddit.com/r/paralegal/comments/1s0ublb/help_organizing_my_to_do_list/) Help organizing my to-do list, 2026-03-22, older. A litigation paralegal supporting two attorneys relies on post-its and separate lists and asks for a coherent system. Organization under a 200-file workload, 2026-06-26, describes duplicated paper, Outlook, spreadsheet and Filevine tracking. - pain: [Pain evidence: Organization under a 200-file workload](https://www.reddit.com/r/paralegal/comments/1ufsqqt/need_best_recommendations_for_space_organizing/) Additional self-reported public account; no independent identity or outcome verification. - method: [Method: Planner task details](https://support.microsoft.com/en-us/planner/add-tasks-to-a-plan) Planner task details supports assignees, dates, progress, links and checklists. Source checked: October 15, 2026. Pain accounts are self-reported. Documentation supports components; this adapted recipe and prompt have not been tested. ## Suggested approach Start when: Daily planning 1. consolidate approved task records from separate sources 2. Keep source references and report unknowns instead of filling gaps. 3. The responsible reviewer checks the report before any separately approved action. ## What you need - Clio Manage is the bounded source for this route. Other task products require their own documented acquisition path before inclusion. - Owner-approved priority policy and review cutoff; approved mapping if records from other systems are supplied. - Firm-approved Excel; optional Copilot entitlement and tenant approval for the exact minimized data. Native Excel analysis can be done manually if Copilot is absent. - Keep raw exports and identifying source pointers in a separate restricted location. The AI workbook contains only approved alias-based tables and visible policy/scope text, never raw client records on another tab. - Use synthetic inputs first. Keep real data in firm-approved accounts and processing, with appropriate access, confidentiality and retention controls. Aliases alone do not anonymize records. Never paste credentials, API keys or unnecessary client details. ## How to use Documentation-checked proposed route; source collection and human approval required - Native export covers Clio tasks only, with completed and outstanding records exported separately. It is not a universal cross-system task collector. - Do not fabricate source IDs, updated_at, timezones or due times missing from the export; inspect the original task or mark unknown. Source-local IDs are never assumed globally unique. Access and setup: - Actual account access, plan and source-data completeness have not been tested. ### 1. Collect the actual task list Tool: Clio Manage Location: Tasks > Outstanding (then Completed if required) > Filters > Apply filters > bottom Export > CSV > Export Choose the authorized users, matters and date range for the selected task queue. Include undated tasks when the scope requires them. Export Outstanding and Completed separately; note filters, capture time and visible record count. Use Expand rows or Print task from the task row menu to inspect full instructions where necessary. Expected output: Native task CSV file(s), plus a scope note. Exact CSV headers must be inspected; the kit headers are not promised native fields. Next step: Keep the raw files restricted; prepare the alias-based input in the next step. Check before continuing: Private tasks may be invisible. Task export is only the selected scope; exporting does not prove all review requests or off-system obligations exist here. Execution status: Official documentation checked 2026-10-15; account and workflow not personally tested Step documentation: https://help.clio.com/hc/en-us/articles/9204982812699-Filter-and-Export-Tasks https://help.clio.com/hc/en-us/articles/9204917906971-Manage-Tasks-in-Clio-Manage ### 2. Map the observed records to the starter input Tool: Excel and authorized staff Location: Separate analysis workbook > Home > Format as Table Set source_system to Clio Manage. Preserve an actual source_id if visible; otherwise assign a source-row reference tied to the retained export and clearly label it local. Assign task_id aliases, then map actual instruction, assignee, status and due date after checking full task detail. Fill updated_at only from observed evidence. Enter timezone and date precision explicitly in Scope. Paste priority-policy.txt into a visible Policy worksheet. Keep rows from multiple exports and systems separate until identity is proven. Create named tables for Tasks. Put the policy and review scope in visible worksheets or paste them into the next prompt. Expected output: tasks.csv plus visible Policy and Scope. If an additional system has no verified extraction, list it as excluded. Next step: Check the mapping against each original source before using AI. Check before continuing: Aliases and missing policy fields are staff-created; do not relabel a native export as the kit schema. Unknown stays blank/unknown, not false or zero. Execution status: Official documentation checked 2026-10-15; account and workflow not personally tested Step documentation: https://support.microsoft.com/en-us/excel/tutorial-import-data-into-excel-and-create-a-data-model ### 3. Review the bounded evidence with Copilot Tool: Excel Copilot, optional Location: Approved analysis workbook > Copilot icon at lower right > Chat only Use Chat only and submit the prompt. Without Copilot: sort by approved policy fields and review duplicate/conflicting source keys manually. Prompt: ```text Using Tasks, Policy and Scope, draft one review queue with source_system/source_id/task_id, matter_alias, exact_instruction, owner_alias, explicit_due_datetime, timezone, status and cited source rows. Apply only the supplied priority policy. Flag missing owner/date/timezone, conflicting versions and potential duplicates; never collapse tasks merely because wording is similar. Updated_at alone is not authority to replace an instruction. Preserve date-only precision. Do not calculate legal deadlines, edit tasks or send reminders. ``` Expected output: Source-linked queue with conflicts and acquisition gaps. Next step: Copy the draft exception list to the reviewer; retain row references. Check before continuing: Check every flagged row and the scope. A fluent answer is not evidence of completeness; no automatic workbook or source-system edits. Execution status: Official documentation checked 2026-10-15; account and workflow not personally tested Step documentation: https://support.microsoft.com/en-us/excel/copilot/get-started-with-copilot-in-excel https://support.microsoft.com/en-us/excel/copilot/frequently-asked-questions-about-copilot-in-excel ### 4. Approve the review result Tool: Responsible staff reviewer Location: Reviewed local worksheet The task owner checks every conflict against the source task, confirms scope exclusions and approves the queue. Keep any unacquired source system in the visible coverage note. Expected output: Reviewed task queue, not an all-systems completeness certificate. Next step: Any external message, source change, payment or deletion requires its own authorized process. Check before continuing: Never treat an empty export as proof that no tasks exist; check filters, permissions and separate completed scope. Execution status: Official documentation checked 2026-10-15; account and workflow not personally tested Step documentation: https://support.microsoft.com/en-us/excel/tutorial-import-data-into-excel-and-create-a-data-model ## What you will get work-register.csv: source_ids, task_ids, matter_alias, instruction, owner, supplied_due_date, status, priority_rule, unresolved_question ## Human review and limits Each owner confirms their items and the manager resolves priorities. Test identical wording on two matters and conflicting completion states. This is a general work register, distinct from A08's attorney approval queue. The assistant drafts or reports only. Check source records and review the output before a human performs any separately approved send or change. No automatic legal decision, money movement, account connection or publication is included. What to measure: In a synthetic pilot, count correctly found exceptions, false alarms, and unresolved inputs. No time or cost saving is assumed. ## Original prepared-input schema tasks.csv: source_system, source_id, task_id, matter_alias, exact_instruction, owner_alias, explicit_due_datetime, timezone, status, updated_at priority-policy.txt: manager-approved rules and source-of-truth policy Synthetic example input: ```text T1/T2: same wording, different matters T3: conflicting completion states T4: missing owner and ambiguous date ``` Expected synthetic output: ```text T1/T2: separate tasks T3: unresolved status conflict T4: owner/date questions, no invented deadline ``` Failure check: Each owner confirms their items and the manager resolves priorities. Test identical wording on two matters and conflicting completion states. ## Starter files Native blank scaffolds and original synthetic examples may use different schemas. Follow NATIVE-INPUT-MAPPING where supplied. These files do not connect accounts or install automation. - [Download starter kit](https://agents.paretoid.com/assets/starter-kits/s06-starter-kit.zip) — All inputs, synthetic examples and review notes in one ZIP. No automation is installed. - [Start here: get the sources and prepare the review](https://agents.paretoid.com/assets/starter-kits/s06/START-HERE.txt) — Documentation-checked acquisition, explicit manual mapping, exact prompts and human review limits - [tasks.csv](https://agents.paretoid.com/assets/starter-kits/s06/tasks.csv) — Blank input template with exact recipe headers. - [tasks.example.csv](https://agents.paretoid.com/assets/starter-kits/s06/tasks.example.csv) — Separate synthetic fixture input. Do not mix these rows into real exports. - [priority-policy.txt](https://agents.paretoid.com/assets/starter-kits/s06/priority-policy.txt) — Blank text input worksheet. Fill its fields with approved evidence; no default assumptions are supplied. - [priority-policy.example.txt](https://agents.paretoid.com/assets/starter-kits/s06/priority-policy.example.txt) — Separate synthetic text input fixture; use with the example CSV files only. - [Expected fixture findings](https://agents.paretoid.com/assets/starter-kits/s06/expected-fixture-result.txt) — Read-only expected output and failure conditions for the included synthetic input files. - [Setup and review checklist](https://agents.paretoid.com/assets/starter-kits/s06/README.txt) — Recipe-specific prerequisites, file mapping, prompt, setup steps, checklist and limits. ## Optional original prepared-input prompt Destination: Your firm-approved AI assistant · prepared files This original prompt uses its own prepared-input schema. Do not mix it with native-step tables without the supplied mapping. ```text Consolidate these deidentified task exports into one proposed work register. Retain source IDs, exact instructions, named owners and explicitly supplied dates. Group potential duplicates without deleting them. Flag contradictory status, missing owners and unclear dates. Rank only by the supplied manager-approved priority rules. Do not calculate legal deadlines, create assignments, mark work done or use the queue to score employee performance. INPUTS tasks.csv: source_system, source_id, task_id, matter_alias, exact_instruction, owner_alias, explicit_due_datetime, timezone, status, updated_at priority-policy.txt: manager-approved rules and source-of-truth policy OUTPUT work-register.csv: source_ids, task_ids, matter_alias, instruction, owner, supplied_due_date, status, priority_rule, unresolved_question Use only these synthetic or firm-approved inputs and preserve source row/page IDs. Keep missing or conflicting evidence unresolved. Return a draft for the named reviewer. Do not send messages, connect accounts, change records or permissions, move money, or make legal decisions. Keep source files unchanged. List missing prerequisites before continuing. ``` Proposed / not tested · editorial prompt Published by Law Firm Agents. Proposed adaptation; not tested. Not legal advice.