How to get the sum of a Custom Field?

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

1 Like

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 custom field, with any value, then export the results to csv.

Hope that helps.

7 Likes

Tks so much Mark !!!

1 Like

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?

1 Like

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?

2 Likes

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:

Great call @Phil_Seeman!

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.

Does this work with Board projects? I don’t see where it would appear.

You’re right, @Eddy_Hueso; there’s not currently a way to get a sum of a custom field in board projects.

You can get around this by running an advanced search report for tasks within the board project. The search results are presented as a list, in which you can then multi-select tasks.

1 Like

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

It looks like this feature is no longer available in the new Projects setup? After multi-select, the tasks pane no longer opens. Help!