Connecting two Templates with formulas

Matt Penta

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. 

Andrée Starå

Hi Matt,

To keep them connected, you'd need to place them in a folder or/and a Workspace and save it as new.

You'd use the folder or workspace a template set instead.

Make sense?

Would that work?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Matt Penta

Ah, I see. That makes perfect sense. It is not very intuitive, but I see how it works now. Thank you very much!

Andrée Starå

Excellent!

Happy to help!