I want to be able to use a dependency like "either/or" instead of "and"
ie: Task 3 can start after either Task 1 or Task 2 is finished, but does not require both tasks to be done.
Is this possible?
=if(or([Task 1]@row = "Finished",[Task 2] = "Finished"),1,0)
Thanks for the reply, but this seems to be saying "if task 1 is complete, task 2 is also complete" but that wouldnt be the case.
Task 1 and 2 wont be completed at the same time. But one of them needs to be done before Task 3.
I misunderstood, you mean how to set the predecessors on a project sheet then right?
Yes. I can make it use both predecessors, but I want it to use one *or* the other.
Someone may correct me if I am wrong, but I am fairly confident you are unable to do that currently in smartsheet. There is not mention of it in the official documentation. I recommend submitting a product enhancement request via the link on the right side of the community webpage.
https://help.smartsheet.com/articles/765727-enabling-dependencies-using-predecessors
Hello, one of our users is getting this error when trying to submit to a form. Other users are able to submit to it without a problem.
Hello! I am pretty new to the intricacies of the platform as I'm looking to lead some project management and automations for the organization I'm in. I have a sheet I am trying to build Automations into, but would like to see if anyone can walk me through how to link this information from other sheets, as they get updated.…
Hello, I use Smartsheet in such way that people are asked to provide data on many records and then that data needs to be approved by one other person (always the same person). I would like to set up an automation that, each morning, checks to see if there are records waiting to be approved, and if there are, sends an…