Asana portfolios in a live spreadsheet
Add the Portfolios table to a sheet as a data source named portfolios and its 9 columns become names your formulas, pivot tables and charts use. Sheets reads it from your Asana workspace each time the sheet opens or refreshes.
Custom fields are columns too, named like the field. Portfolios, goals and time entries need one of Asana's paid plans; on a free workspace those tables are empty.
Formulas on this table
=list.portfolios(name) Every name, once. Spills the distinct name values down the column: the row labels for the formula above.
=data.portfolios.count(id, name, "<>") Rows with a name. Counts the rows whose Name is not empty.
Columns
| Column | In formulas | Type |
|---|---|---|
| ID | id | Text |
| Name | name | Text |
| Owner | owner | Text |
| Owner ID | owner_id | Text |
| Start date | start_date | Date |
| Due date | due_date | Date |
| Public | public | Yes / no |
| Created at | created_at | Date and time |
| Link | link | Text |
Other planning tables
Your portfolios, live
Tasks, projects, people, portfolios, goals and time entries become tables that formulas, pivot tables and charts read directly. Open and overdue work, workload per person and completion trends stay current without exporting.