Connecting two Templates with formulas

Matt Penta
edited 12/09/19 in Smartsheet Basics

I have a group of sheets that i have created templates for. I was wondering if there was anyway to have the formulas in the sheets not break when templates are created and to point at each other instead of having to be redirected every time a template is used.

Ex: Sheet 1, 2, & 3 all point to each other. I have added all three sheets as templates for future jobs, but the formulas always break/point back to previous sheets when the template is loaded and I have to go in and manually correct each formula.

Is there a way to group these three sheets into a single template that will not break all the formulas when loaded? This would say a large amount of time each time the templates are loaded for a new job.