#1
|
|||
|
|||
"OR"-function in dependencies
Hello,
We're looking for a way to set up dependencies for the following situation: Task 3 starts after Task 1 OR Task 2 is completed, whichever comes first. Can someone help us this the right way, or the best workaround? Thank you Wouter |
#2
|
|||
|
|||
You can put a comma in the Predecessors to separate tasks.
See attached. |
#3
|
|||
|
|||
The above wont work, as it relies on both tasks being complete.
Preds/succs arent conditional. If task 2 is linked from the completion of tasks 1 and 2, then both need to be complete before it will start. The only way I can think of is to put a note on the task, and manually check it when its going to start. You may be able to use resourcing, by allocating the same resource to each task, setting a resource limit of 2, and linking from the earlier finishing task, then resource levelling, but I'm not a fan of levelling as it tends to do things you dont want. If however you dont have resourcing, it could well solve the problem- take a bit of thinking, but its a possible solution. |
Tags |
dependencies, or-function |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Worksheet function returns "Invalid or Unqualified Reference" | SerenityNetworks | Excel Programming | 2 | 10-27-2017 08:00 AM |
Excel 2016 "IF" Function Problem with 3 Ranges | Excelsior44 | Excel | 3 | 02-07-2017 05:46 PM |
Google "=Filter()" function excel equivalent. | Sadodare | Excel | 0 | 08-01-2016 11:15 AM |
"one click" function to switch between branded presentations | davidolone | PowerPoint | 0 | 01-16-2016 01:54 PM |
How to choose a "List" for certain "Heading" from "Modify" tool? | Jamal NUMAN | Word | 2 | 07-03-2011 03:11 AM |