# Using Advanced Search to Find All My Incomplete Tasks That Are in Completed Projects

**URL:** <https://forum.asana.com/t/using-advanced-search-to-find-all-my-incomplete-tasks-that-are-in-completed-projects/709590>\
**Category:** Ask the Community\
**Tags:** advanced-search\
**Created:** [16 February 2024 22:26 UTC](https://forum.asana.com/t/using-advanced-search-to-find-all-my-incomplete-tasks-that-are-in-completed-projects/709590 "2024-02-16T22:26:42Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rob\_Kelley](https://luna1.co/8d76cd.png) [@Rob\_Kelley](https://forum.asana.com/u/Rob_Kelley)\
**Post date:** [16 February 2024 22:26 UTC](https://forum.asana.com/t/using-advanced-search-to-find-all-my-incomplete-tasks-that-are-in-completed-projects/709590/1 "2024-02-16T22:26:42Z")

</div>

We have accumulated a lot of completed projects. Some of them still have incomplete tasks in them, and some of those are mine. There are enough of them, that they clutter-up “My Tasks”.

I’d like to be able to create a list of all my incomplete tasks that are located in complete projects so I can quickly assess them and either delete or do them.

---

<div class="post-metadata">

**Author:** ![Larry\_Berger\_lpb](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/larry_berger_lpb/32/276017_2.png) [@Larry\_Berger\_lpb](https://forum.asana.com/u/Larry_Berger_lpb)\
**Post date:** [17 February 2024 02:00 UTC](https://forum.asana.com/t/using-advanced-search-to-find-all-my-incomplete-tasks-that-are-in-completed-projects/709590/2 "2024-02-17T02:00:33Z")

</div>

Welcome, @Rob_Kelley,

I think in native Asana you would have to do this in two steps, and assuming you have access to Universal Reporting and Portfolios (not required but easier if you have that feature too) in your plan.

First, you need to get the list of completed projects. You could do that with advanced search clicking the Completed box, but then in search results look at the Projects tab:

 ![image](https://us1.discourse-cdn.com/asana/original/3X/e/1/e1b421cf202088f22e0efdb483d20f79d45cba87.png)

That’s your list of completed projects, the domain over which you want to find your incomplete tasks.

An alternate way to do the above would be Universal Reporting, like this:

 ![image](https://us1.discourse-cdn.com/asana/original/3X/0/7/074f9a61d281f7631ab2030b34e07c28bdf715f2.jpeg)

Then click the segments to get the individual project names.

With either of the above giving you the list of projects, now create a Portfolio containing all those projects to use in the next step (or skip this if you want to specify them below).

Now create (another) Universal Reporting chart like this specifying that portfolio in which to search across, for incomplete tasks; also filter on tasks assigned to you (not shown):

 ![image](https://us1.discourse-cdn.com/asana/original/3X/f/8/f82ff1cc0f56423a520779facc83d31e898b0926.jpeg)

(If you want to avoid the portfolio, you can search over “Specific projects;” specify your list right in that field and skip the portfolio step.)

That’s long-winded, but might not take you that long, depending, and I believe is the only way to get your answer natively in Asana.

Thanks,

Larry

---

<div class="post-metadata">

**Author:** ![Rob\_Kelley](https://luna1.co/8d76cd.png) [@Rob\_Kelley](https://forum.asana.com/u/Rob_Kelley)\
**Post date:** [19 February 2024 15:26 UTC](https://forum.asana.com/t/using-advanced-search-to-find-all-my-incomplete-tasks-that-are-in-completed-projects/709590/3 "2024-02-19T15:26:08Z")

</div>

Thanks. I see how this would work.

Since the sheer number of completed projects is long, it would be very helpful to have the option in Advanced Search to filter by “Project Status” (On Track, At Risk, Complete…) much the way we are able to filter based on “Task Status” (Complete, Incomplete).

---

<div class="post-metadata">

**Author:** ![Larry\_Berger\_lpb](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/larry_berger_lpb/32/276017_2.png) [@Larry\_Berger\_lpb](https://forum.asana.com/u/Larry_Berger_lpb)\
**Post date:** [19 February 2024 15:37 UTC](https://forum.asana.com/t/using-advanced-search-to-find-all-my-incomplete-tasks-that-are-in-completed-projects/709590/4 "2024-02-19T15:37:51Z")

</div>

@Rob_Kelley, It would be good to add a new post in #Product Feedback to this effect and vote with the purple vote button there.

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/system/32/276370_2.png) [@system](https://forum.asana.com/u/system)\
**Post date:** [26 February 2024 15:38 UTC](https://forum.asana.com/t/using-advanced-search-to-find-all-my-incomplete-tasks-that-are-in-completed-projects/709590/5 "2024-02-26T15:38:30Z")

</div>

Closed on 26 February 2024 15:38 UTC

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
