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:

Project 1

Project 2

Phase 2 Projects

Project 3

Project 4

Phase 3 Projects

Project 5

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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!