Sign in to join the conversation:
Hi,
I have multiple projects to be managed under a program. I have a task1 under Project A which has dependency on task2 of Project B. How can I mark dependencies between two project tasks?
thanks,
Pragati
Hello,
Thanks for your post! It sounds like you have multiple Project Sheets, and some of these projects have tasks that are dependent upon tasks in other projects. Smartsheet doesn't currently support cross-sheet dependencies, but there are some workarounds that others have used. You can also submit a Product Enhancement Request with the quick link to the right.
To workaround this limitation, one option is to insert a row in the sheet which dependent sheet, then use cell links to populate the row with the task information from the sheet which contains the predecessor. Once this row is inserted and cell linked, you can then link tasks to this new row with predecessors.
Depending on the size of your projects, you may also be able to consolidate your Projects into a single Project Sheet with each project separated by a level of Hierarchy. I've included some related links below:
I hope this helps!
Isaac J
Smartsheet Support
My reminder in smartsheet automation is set to trigger every day starting 12/05/2025 at 8am (gmt+1) and the condition is to send the reminder to the contact in the contact list if the reminder flag is set to 1 and the status is not one of DONE. Currently on the sheet, a task has the reminder flag set to 1 and the status is…
I am attempted to export to excel. I have two different smartsheet documents to export. One of them exported to excel fine, but not the other. This happened a few weeks ago. I make sure all columns were the correct size & no cells were hidden. "We have found a problem with (file) Do you want us to try and recover as much…
Hi Everyone, My IT has a lot of confusion on what we access we really need to have for certain people. What is the difference between a "Member" and a "Licensed User?" We have a lot of sheets that have owners who do all of the changes of the sheet. I know that they need to be licensed users. But then, we have a lot of…
