Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
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 Smartsheet Friends! I recently switched jobs and once again working at a company that uses Smartsheet (hooray!). That said my skills are a little rusty, and I'm struggling with a basic update request automation. I've added a checkbox column titled 'Product Owner Update'. The intent, is that when a user checks the…
Hi My team have a list of projects they are working on. I want to prompt them for a weekly update that will ask them to populate these fields - RAG Status , Progress this week , Plan Next week, Risks/Decision/Issues , Details Then i can create a dashboard showing only this weeks info but i have the repository in the back…
How to use Smartsheet AI/automation to automically write project status?
