The Scenario
A new project delivery lead joined the team two weeks ago. She inherited three active projects and an Excel workbook with 50 OneDesk task IDs spread across them — all collected from handoff notes, Slack threads, and a shared doc that got frozen when the previous lead left.
She wants one thing before her first status meeting with the client: a single Status Summary worksheet that shows task name, current status, assignee, due date, and days until due for each of those 50 tasks.
The previous lead used to maintain this manually. It was always two weeks out of date.
The bad version:
- Open OneDesk and look up each task ID in the list
- Note the task name, status, assignee, and due date
- Switch to the workbook, paste the values into the right row, calculate days remaining with a formula
- Repeat 49 more times while hoping no one changes a task's status in OneDesk while you're partway through
The workbook is supposed to be a live snapshot. A manually assembled snapshot from 50 separate lookups is not a snapshot — it's a reconstruction.
The client meeting is tomorrow morning.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the task IDs, fetches live details from OneDesk, creates a new worksheet, and writes the summary table in one pass.
Fetch details for every task ID in column A using OneDesk, then create a Summary worksheet with columns: Task ID, Title, Status, Assignee, Due Date, Days Remaining. Calculate Days Remaining as the number of days between today and the due date — use a negative number if the task is already past due.
One prompt. A new worksheet exists with current data from OneDesk, including the days-remaining calculation built in.
What You Get
- A new Summary worksheet created in the workbook
- Task ID, Title, Status, Assignee, Due Date, and Days Remaining populated for all 50 rows
- Days Remaining calculated from today's date, negative for overdue tasks
- Any task ID that returns an error noted in the Title column so missing records are visible
What If the Data Is Not Quite Ready
Some tasks belong to a different OneDesk workspace
The 50 IDs span two OneDesk projects. Tasks from Project Alpha look up fine; tasks from Project Beta need a different project context.
Fetch details for each task ID in column A from OneDesk. For any ID that returns not found, try the lookup against the secondary project. Write the results into a Summary worksheet with columns: Task ID, Title, Status, Assignee, Due Date, Days Remaining, and the Project name for each task.
The summary needs to be sorted by status, not by original order
The delivery lead wants to see all overdue tasks first, then in-progress, then not started.
Fetch OneDesk details for each task ID in column A. Create a Summary worksheet with Task ID, Title, Status, Assignee, Due Date, Days Remaining. Sort the Summary worksheet by status in this order: Overdue tasks first (Days Remaining is negative), then In Progress, then Not Started, then Closed.
You want to write status and assignee back into the original worksheet, not a new one
The delivery lead wants the data inline with the original list, not in a separate worksheet.
For each task ID in column A of the Open Tasks worksheet, fetch the task title, status, and assignee from OneDesk and write them back into columns B, C, and D respectively. Then sort the worksheet by column C (status) in ascending order.
Full status prep for the client meeting: fetch, sort, highlight overdue, and note errors
Fetch OneDesk details for every task ID in column A. Create a Summary worksheet with Task ID, Title, Status, Assignee, Due Date, Days Remaining. Sort by Days Remaining ascending so the most overdue tasks appear first. For any task ID that returns an error, write "lookup failed" in the Title column. After creating the worksheet, write a note at the top of the Summary worksheet showing the count of overdue tasks, in-progress tasks, and lookup failures.
The delivery lead opens the Summary worksheet tomorrow morning and has a current view of every task before the call starts.
Try It
Get the 7-day free trial of SheetXAI and open the inherited task list that has been sitting out of date since the last handoff — ask it to create the status summary worksheet from live OneDesk data before your next client sync. Also worth reading: how to flag overdue tickets using live due-date lookups, and the hub overview of all four methods for connecting OneDesk to Excel.