#1
|
|||
|
|||
20 day gap indicator
Hi All,
I'm looking for a formula that will indicate/highlight if the gap between two tasks is greater than 20 working days. For example, Task A is the predecessor of task B and there must be a 20 working day gap between the two tasks. If the gap become greater than 20 working days, I need an indicator to highlight this against task B. Does anyone have a formula to achieve this? Any help would be appreciated Cheers Planner18 |
#2
|
|||
|
|||
Unfortunately you cannot write formulas in Project that refer to more than one task.
|
#3
|
|||
|
|||
Hi Julie,
That's a pity. Any thoughts how this can be achieved any other way? Cheers Planner18 |
#4
|
|||
|
|||
I am guessing you are setting the lag on the link relationship? Have you considered putting a deadline on task B? You will be a visual flag if the recalculation causes the finish of the task slips past the deadline.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Office 2013: language indicator in the status bar? | franklekens | Word | 8 | 08-30-2015 01:08 PM |
Task Indicator - All predecessors complete true/false, y/n | jdove78 | Project | 2 | 10-10-2012 05:53 PM |
On-screen indicator for overtype mode? | carrfamily@mindspring.com | Word | 3 | 04-29-2011 01:56 PM |
Next Page Indicator | mkstreet | PowerPoint | 0 | 12-08-2010 11:36 PM |