Hello! Is there any way to use a portfolio rollup in a formula? I’ve been struggling with a way to track a project’s overall budget inside of Asana and this would be a game-changer, so I’m hoping I’m missing something!
Here’s one example of what I’m looking to do at the portfolio level:
Project Budget (# Number)
Actual Spend (Rollup)
Remaining (Formula: Project Budget - Actual Spend)
Hi everyone, I’m excited to announce you can now use a new rollup function in formula custom fields to aggregate values from projects up to the portfolio level. This powerful enhancement allows you to create a single source of truth for resource management data, significantly improving reporting, workload planning, and automation capabilities.
Previously, rollups were limited to portfolio views. With this update, data created via these rollup formula custom fields can be used in project-level automations, universal and portfolio workload, reporting features, and as inputs to other formulas.