How to get the sum of a Custom Field in a Project ?

Hi @Pedro_GCA To get the sum, you just multi-select all of the relevant tasks. The total comes up in the task pane: [image] Or, if you want to look at large numbers of tasks and don’t want the hassle of scrolling down to the bottom, just run an advanced search for all tasks associated with that c…

Hmm, I don’t actually see a “total” at all. Can you specify what you did, other than select the tasks? Thank you!

Hi @Alyssa_J_Gavinski The total should automatically appear in the task pane, without having to do anything additional. Are you using a number-based custom field?

I am don’t see a total either when I select multiple tasks. See attachment.[39]

@Erjon_Metohu Are you sure that “Deal Value” is a Number custom field? For Number field types, you should see the total to the right of where it displays Multiple Values. Perhaps your field is a Text field?

Good call Phil, it was a text field. It works! :slight_smile: Now, I have a another issue the numbers column is so narrow you can barely see the full numbers and it doesn’t seems you like you can resize column widths. :frowning:

If the selected tasks are more than 50 ti will not showing me the total, is there other way?

Hi @Juan_Maceda The 50 tasks thing is a bit limiting. The quickest and easiest way around this is to export the project as a CSV and just SUM the relevant column.

How to get the sum of a Custom Field?

English Forum Ask the Community

Sami_Linnanvuo1 26 March 2019 14:24 15

The Screenful dashboard for Asana can report sums of custom fields out of the box. Here are some examples screenshots of custom field reports:

Summe bei mehr als 30 Unteraufgaben

Topic		Replies	Views
Add up custom fields in My Task View Ask the Community	6	4828	30 May 2018
Tally custom field values in advanced search report Product Feedback custom-fields , reporting , formulas , advanced-search , google-sheets	13	4664	23 September 2021
Output a sum of custom fields using API Developers & API	2	3358	12 July 2017
Showing sum of project's numeric field (costs etc.) in Portfolios Product Feedback custom-fields , portfolios , launched	22	4722	25 July 2024
Assigning time and tracking time for tasks Ask the Community time-tracking , custom-fields , tasks	6	19104	30 July 2020

How to get the sum of a Custom Field?

Related topics