Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-16-2020, 08:05 AM
HMBVW HMBVW is offline "OR"-function in dependencies Windows 10 "OR"-function in dependencies Office 2019
Novice
"OR"-function in dependencies
 
Join Date: Jun 2020
Posts: 1
HMBVW is on a distinguished road
Default "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
Reply With Quote
  #2  
Old 07-29-2020, 11:46 AM
kkline116 kkline116 is offline "OR"-function in dependencies Windows 10 "OR"-function in dependencies Office 2013
Novice
 
Join Date: Jul 2020
Posts: 5
kkline116 is on a distinguished road
Default

You can put a comma in the Predecessors to separate tasks.

See attached.
Attached Images
File Type: png Or function.png (11.5 KB, 8 views)
Reply With Quote
  #3  
Old 07-31-2020, 12:14 PM
Guloluseus Guloluseus is offline "OR"-function in dependencies Windows 7 64bit "OR"-function in dependencies Office 2010 32bit
Competent Performer
 
Join Date: Mar 2013
Posts: 168
Guloluseus is on a distinguished road
Default

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

Tags
dependencies, or-function

Thread Tools
Display Modes


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
"OR"-function in dependencies 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
"OR"-function in dependencies How to choose a "List" for certain "Heading" from "Modify" tool? Jamal NUMAN Word 2 07-03-2011 03:11 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:13 PM.


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