Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Filter for tasks that should have started

2 replies [Last post]
Tue, 2015-06-23 11:14
Wayne Ford
User offline. Last seen 8 years 11 weeks ago. Offline
Joined: 23 Jun 2015
Posts: 4
Groups: None

I need some assistance with a filter that will show task that should have started by the status date but still show now actual start or % progress

Top

Replies

Mon, 2015-07-13 16:27
#1
Tom Boyle
User offline. Last seen 3 weeks 3 days ago. Offline
Joined: 28 Nov 2006
Posts: 304
Groups: None

Hi Wayne,

It's not clear what assistance you might need.  MSP has two built-in filters that would seem to fit the bill:

1. "Should Start By..."  This filter shows all tasks with no Actual Start (AS="NA") and whose scheduled start is less than a date you are prompted for.  (Remember AS is the limiting factor here.  You can have an AS with 0% Complete, but you can't have >0% Complete with no AS.)  You could easily copy and modify this filter specification to use the Status Date.

2.  "Late Tasks"  This filter shows all tasks with Status = "Late".  According to support.office.com,

  • If the timephased cumulative percent complete does not reach midnight on the day before the status date, then the Status field contains Late.

    So this is a bit more expansive, actually looking at the %Complete value and judging if adequate progress is being made.

Personally I don't use either of these on a regular basis, so I can't vouch for their overall usefulness.

Top
Mon, 2015-07-13 16:26
#2
Tom Boyle
User offline. Last seen 3 weeks 3 days ago. Offline
Joined: 28 Nov 2006
Posts: 304
Groups: None

Hi Wayne,

It's not clear what assistance you might need.  MSP has two built-in filters that would seem to fit the bill:

1. "Should Start By..."  This filter shows all tasks with no Actual Start (AS="NA") and whose scheduled start is less than a date you are prompted for.  (Remember AS is the limiting factor here.  You can have an AS with 0% Complete, but you can't have >0% Complete with no AS.)  You could easily copy and modify this filter specification to use the Status Date.

2.  "Late Tasks"  This filter shows all tasks with Status = "Late".  According to support.office.com,

  • If the timephased cumulative percent complete does not reach midnight on the day before the status date, then the Status field contains Late.

    So this is a bit more expansive, actually looking at the %Complete value and judging if adequate progress is being made.

Personally I don't use either of these on a regular basis, so I can't vouch for their overall usefulness.

Top