Tally custom field values in advanced search report

I’ve got an advanced search report, where I want to pull all tasks completed that have a certain numeric custom field (e.g. hours, or dollar value). The report works fine, but I want to see the grand total (sum) of that field.

The only way I can seem to do it now is to export the report to CSV and then sum the column manually but that’s a bit of a headache, because I have several of these reports I want to run. I’m hoping there’s a plugin that could help with this. I know Asana has a Google Sheets integration, but that seems to only work from Portfolios and not custom searches, right?

The existing functionality lets you select the tasks manually to see the total sum – but you can’t sum more than 50 tasks, so that really doesn’t work for my use case, where I have more than 50 tasks to add up.

@Marie, @Emily_Roman, It appears that the sums of numeric custom fields that were in the bottom toolbar have disappeared. Wondering what’s up?

Thanks,

Larry

1 Like

There is another topic opened a couple of hours ago about this disappearance. Looks like the only location with a sum is below a section now…

1 Like

Hi Larry, this is now resolved :slight_smile:

@Justine_D once you’ve ran your report, if you multi select all your tasks, you will get the sum of your custom field in the tooltip at the bottom of your screen:

4 Likes

Is there a keyboard shortcut to quickly select all the tasks? What if I have say, 100+ tasks that show up? Do I manually need to scroll to the bottom of that list?

Yes! We’ve several shortcut available to multi-select tasks, you can check them out here :point_right: https://asana.com/guide/help/faq/shortcuts

I can’t find a “select all” shortcut but maybe I’m just missing it - can you confirm if there’s a shortcut or another way to “select all tasks” in an advanced search report?

I’m going to add this as a feature request because even if there WAS a shortcut to select all, it won’t sum more than 50 tasks :frowning:

@Justine_D shortcut is: click first task, hold Shift key, click last. You can also cherry pick by holding Ctrl or Cmd. Indeed, no more than 50 tasks allowed!

1 Like