Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-23-2017, 02:49 AM
Planner18 Planner18 is offline 20 day gap indicator Windows 8 20 day gap indicator Office 2010 32bit
Novice
20 day gap indicator
 
Join Date: Oct 2014
Posts: 14
Planner18 will become famous soon enough
Default 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
Reply With Quote
  #2  
Old 03-23-2017, 03:46 AM
JulieS JulieS is offline 20 day gap indicator Windows 10 20 day gap indicator Office 2016
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Unfortunately you cannot write formulas in Project that refer to more than one task.
Reply With Quote
  #3  
Old 03-23-2017, 07:21 AM
Planner18 Planner18 is offline 20 day gap indicator Windows 8 20 day gap indicator Office 2010 32bit
Novice
20 day gap indicator
 
Join Date: Oct 2014
Posts: 14
Planner18 will become famous soon enough
Default

Hi Julie,

That's a pity. Any thoughts how this can be achieved any other way?

Cheers

Planner18
Reply With Quote
  #4  
Old 03-23-2017, 04:09 PM
JulieS JulieS is offline 20 day gap indicator Windows 10 20 day gap indicator Office 2016
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
20 day gap indicator Office 2013: language indicator in the status bar? franklekens Word 8 08-30-2015 01:08 PM
20 day gap indicator Task Indicator - All predecessors complete true/false, y/n jdove78 Project 2 10-10-2012 05:53 PM
20 day gap indicator 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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:00 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft