Dynamic Formula to links multiple sheet based on Sheet Name


Dear Team,

I have multiple folders (Individual Project) in workspace which has multiple sheets in each project folder. Is there any dynamic way or formula to link the individual sheets data (example Total Budget and Actual Cost) based on the Sheet name (Main Sheet contains a Columns Projects Name which has each Project Sheet Name) to Main Sheet and for every New Project Formula should updated whenever user enter the Project Sheet Name.

Appreciate your prompt support.

Thanks and best regards.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!