Hi All,
Is there a way to make an advanced search that allows to see all tasks completed within some period of time in project / team in which the actual time column is visible (so we can sum it up?)
We used to make such saved search as a reports to our clients. We have been using custom time filed (Number type) with time entered manually.
If there is a way for it - for my team is one less tool to use (we were using toggl and clockify for now) but it would be great to have this kind of report in asana.
I would also like Actual Time to show up in the search results. Charts are useful but often I want to do highly customized searches, and just see the total time for that set of tasks. Creating a chart is often more cumbersome and also doesn’t show you the list of tasks.
Although this won’t resolve my need, I’m wondering how you do this? I don’t see any way to change the default set of columns in the results of an Advanced Search.
Actually, click any chart segment and it drops you into search results view to see the tasks that make up that segment (but you can’t change the columns here; you have to start with Advanced Search as described above).
The search results do show the Actual Time field now. But a total sum is not given at the bottom. If we got that, it would be very helpful to us. Just for that one feature, we currently have to add all the tasks from the search result to a temporary project. Then we can see the sum, and then we have to remove all the tasks from that temporary project.
@Patryk_D Perhaps you missed it for the same reason I did. The dropdown list is only showing “Recent Fields”. Ignore the options and start typing “Act…” and you’ll see “Actual time”.
Right, as you’ve discovered, the search results don’t offer those total sums. If you’re on Business or Enterprise, and if it might simplify your workflow, perhaps you could have a rule that multi-homes the tasks that need summation to a (private) project. Then you wouldn’t need to go through the extra temporary steps you need to now??
On the typo, I think you’ll gain edit rights here eventually; for now I made that change.
We are on a Business plan. We haven’t yet gotten into using rules. That’s a powerful capability that we need to start exploring. Thank you for the suggestion.