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:
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
I have an Auto-Number column in my Smartsheet containing approximately 100 employees. I would usually add new employees at the bottom of the list and, once the onboarding process was completed, sort the names alphabetically. The Auto-Number column has always served as a quick indicator of the total number of employees on…
I was billed for an annual renewal with no heads-up and was surprised to find that, when I logged back in to check, my historical data was gone, along with my paid account access to direct support to address the matter. I have had a paid, 3-user team subscription for over 7 years and am the only admin—nothing has changed…
I have two automations set up on a sheet, both triggered by changing the contents of a cell (same cell for both). One automation MOVES the row to another SS (basically a cemetery for dead requests). The other sends an email to a specific person to let him know that the request was denied. This Email automation was added…
