Formula custom field with Advanced Editor

Hi everyone :wave: I’ve got a quick update to share with you on Formulas!

The past two months saw the introduction of the Formula field in Asana. Starting with the Basic Formula editor which was quickly followed by the inclusion of the Advanced Editor that opened a wide range of new possibilities!

Today, I’m happy to share that rollups are now available to use in Formula fields within Portfolios! :tada:

In case you are not aware already, roll ups were introduced earlier this year - they are essentially special custom fields which you can add to your portfolio. They automatically provide the sum of a number field (which is added to your custom fields library) of all the tasks within a project and displays that sum in your Portfolio.

Up until now, you could add to your portfolio, roll ups of number fields as well as formula fields that are within your projects. But now, you can add to your portfolio, a formula field which can also include roll ups within its equation, either using the Basic editor or the Advanced Editor, as per below!

Gif rollups formula for portfolio

As per the above example, you could take the roll up of all estimated time and subtract that from the roll up of the actual time to get the time remaining of the entire project. Other examples could include finding differences between rollups of budget vs spent as well as other key metrics.

We hope you find this update useful and look forward to reading all your use cases and the roll ups you are planning on using in your Portfolio’s formula fields. Let us know in the comments below!

Please note, this update is being gradually rolled out and it will be available to all Business and Enterprise customers soon.

4 Likes