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
This may seem super basic, but I work in tandem with 4 different teams and need to construct a calendar/timeline for all of these separate departments. What is the easiest way to gather the information? Some teams use smartsheet, some use excel, but none have the same format and none really "talk" with each other - hence…
I have a sheet that I am using to collect COI from faculty, but our faculty often are involved in multiple activities that often leads to them inputting several COI entries. I've managed to create a duplicate checker to see which faculty members have entered their COI twice, but that doesn't necessarily solve my issue of…
I have a number of automation that send notification emails to clients. These are automations that have worked successfully for years, and suddenly they stop. I am a recipient on many of these notification emails, and I realize that I have stopped receiving these notifications as well as of Jan. 26, 2026. It's a…
