dependencies in multiple sheets

We manage a complex program through smartsheet. Our Program has multiple complex projects. Each Project has its own separate sheet that has project plan.

How do I use dependency function in smartsheet through multiple sheets. I.e. one project in one sheet might have dependency on other sheet. How we can depict these dependencies and calculate/estimate critical path.

What’s the best way to create a visual graphic to explain this to executives




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!