Hey @Marie and my fellow Asana peeps! Happy Monday! I have a team that is moving away from using their Portfolio for their status meetings because they need to add columns with financial info to track campaign spend and pacing. They need these columns to calculate so they can see if they are on track or off track. Since we are seeing more functionality in the way of spreadsheet views, I am wondering if there is any plans to add functionality to the portfolio to enable formulas and calculations on those fields. I know there is some simple math like totals in workflow view with capacity and time which is great. But we suddenly find ourselves with this next level need and functionality in the projects view of the portfolio. I would love to keep my team in Asana and the lack of the ability to do stuff like this is giving them a reason to move away from the platform and creates the need for them to create and maintain a separate document. Plus their conversations impact the projects and that info will become disconnected from the projects which should be our single sources of info. Looking forward to hearing some feedback from the community and Asana. Cheers, Stephanie

Hi @StephanieC :wave:t3: Great question, and thanks for providing some context and your vision for this feature request, this is super useful! I don’t believe this is our immediate plans, but since we’re starting to implement formulas at the project level (Sum), I’m confident we will eventually add them to Portfolio too :slight_smile: I’ll make sure sure to keep you posted via this thread as soon as I have some update!

Do you have any idea when this feature may arrive for projects. It could be gamechanging for us?

We are looking for this feature too. Im CPO and to prioritize the feedback we use the ICE framework that basically make some calculations to define what to do first. Now we have to do s calculation in excel and after to include in a numeric column, any round that we parametrize we have to update and make the calculations again woth third software ( excel, Airfocus…)

@StephanieC and @Guillermo_Lopez, See also: [image] Computed Fields on Tasks Features Launched @Andrew_Szeto, @Kelsea_Nemcek, and others, Until/if this is natively available in Asana, consider (disclaimer: I’m the creator): @Andrew_Szeto, specifically regarding your OP and the Urgency/Impact need, consider also: [image] Hope one of those might help some folks, Larry

Hi Is this feature available yet (calculated field) I am wanting to add a field that will calculate WSJF…

Hello, adding formulas in Column will be really grt . Please update if any plan in future

@Rahul_Deshmukh @Christopher_Shorten While we wait Asana to implement the calculated column, I just wanted to let you know that the Analytics & Reports add-on by Screenful supports calculated columns. You can apply formulas to any of your custom fields in the task, project, or portfolio level. You can learn more about this feature in this blog post. [1]

We will have countless hours if this game changing feature was available in the Asana list view. It would improve productivity for engineering organizations that size upwards of 1000 humans offering speed at scale for product management, roadmap planning etc.

Ability to add formulas to columns in portfolios and projects

Asana Community Product Ideas Features Launched

Larry_Berger_lpb 20 November 2020 17:42 5

@StephanieC and @Guillermo_Lopez, See also:

Topic		Replies	Views
Formulas and Rollup for Formulas: A Game Changer for Asana Ask the Community	0	1123	14 December 2024
Introducing Formula Custom Fields! Product Launches	43	13459	27 July 2023
Columna o Campo con ingreso de Fórmula Comunidad de Asana feedback-es	7	2753	5 September 2023
Computed Fields on Tasks Features Launched custom-fields , tasks , launched	136	25994	2 August 2023
Calculate custom field value Ask the Community custom-fields	66	25674	31 July 2024

Ability to add formulas to columns in portfolios and projects

Related topics