Automatically move a sheet within a sheet?
So I have created a production sheet that displays all my projects and where they're at in its state (Phase 1 through Phase 5). For example:
Phase 1 Projects:
Phase 2 Projects
Phase 3 Projects
Each "project" is a hyperlink. When clicked on, it sends the user to the corresponding project's smartsheet with its own set of tasks to complete.
My question is, is there a way to automatically move these projects down phases if I complete certain tasks from the project's own smartsheet?
Help Article Resources
Check out the Formula Handbook template!