filtered date range shows the completed tasks!

[Majid]

Hello,
Is there any way to filter the projects by date range but
not seeing the 100% completed projects?
Thank you in advance

 

[John Beamish]

1. On the Formatting toolbar, look for the AutoFilter button (it looks like
a funnel). Click on that. You will see a tiny triangle appear at the top
of each column.

2. Click on the tiny triangle at the top of the % Complete column. In the
dropdown list you can do either:

(a) Click on "In Progress". This will display all tasks that have started
but are not complete.
Or
(b) Click on "(Custom ...)" which will open a dialog box. You want "Is
greater than or equal to" and "0%"; the "and" option; "Is less than or equal
to" and "99%". This will display all tasks (even if they haven't started)
and are not complete.

3. On the Formatting toolbar click on the Filter and choose "Date Range".

Now you will see the tasks you are interested in. If you don't want to see
the Summary tasks then click on Tools | Options | View tab and clear the
"Show summary tasks" checkbox.

JLB, PMP

 

[Majid]

Thank you John

-----Original Message-----
1. On the Formatting toolbar, look for the AutoFilter button (it looks like
a funnel). Click on that. You will see a tiny triangle appear at the top
of each column.

2. Click on the tiny triangle at the top of the % Complete column. In the
dropdown list you can do either:

(a) Click on "In Progress". This will display all tasks that have started
but are not complete.
Or
(b) Click on "(Custom ...)" which will open a dialog box. You want "Is
greater than or equal to" and "0%"; the "and" option; "Is less than or equal
to" and "99%". This will display all tasks (even if they haven't started)
and are not complete.

3. On the Formatting toolbar click on the Filter and choose "Date Range".

Now you will see the tasks you are interested in. If you don't want to see
the Summary tasks then click on Tools | Options | View tab and clear the
"Show summary tasks" checkbox.

JLB, PMP




.