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
Hello, I'm working through the writing formulas optional activity and in the 'Nested IF function - Progress Column' task it directs you to put in the following formula '=IF([% Complete]@row = 0, “Empty”)'. However, when I put this formula into the spreadsheet, '04a_Marketing Request Tracker - Formulas', I get an…
Currently Triggering recurring workflows are only supported at the top of each hour. For instance 10:00, or 11:00, etc. Would like the ability to set 10:30 or 10:45. Perhaps the inteface can stay hourly so it doesnt get huge, but have the ability to manually edit the time directly to any custom time.
I have an automation that has a condition where I am looking at the column "LEA Interco Supporting Site(s)" and trying to find columns that have the value "Fort Loramie" in them. This works well when "Fort Loramie" is the first item listed in the cell, but it doesn't work when "Fort Loramie" is the second or third value in…