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.