Formula-driven KPIs
Total tasks, completed tasks, needs-attention tasks, upcoming due dates, and completion rate update from the Tasks sheet.
What is already built
Status and project summaries
See task counts by reporting status and open or at-risk work for each sample project.
Native chart
A workbook chart reads its values from the formula-backed status summary, so edits remain traceable.
Typed task table
Real dates and checkboxes, filtered headings, status and priority dropdowns, and conditional formatting for risk.
Setup and mapping guide
A dedicated sheet shows how Asana export fields map to every report column.
Excel and Sheets ready
Use the .xlsx in Excel or import it into Google Sheets, then replace the illustrative rows with your own export.
Connect it to current Asana data
Export
Use Asana Exporter to pull one project or every project in a portfolio into Google Sheets.
Map once
Keep the template headings and paste or map task name, project, assignee, due date, completion, section, priority, status, and tags.
Refresh
Save the export and choose manual, hourly, daily, or weekly refresh so the reporting source stays current.
The workbook is local. Asana Exporter runs inside Google Apps Script; Cody Labs operates no server that receives your project data.
Start with the sample, then make it yours
The workbook includes realistic illustrative tasks so you can inspect every KPI, status rule, and chart before replacing the data.
Download Asana portfolio report template