How to get the sum of a Custom Field?


#1

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


#2

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.


Assigning time and tracking time for tasks
Add up custom fields in My Task View
#3

Tks so much Mark !!!


#4

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


#5

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?