Creating templates of multiple sheets that share data
Hello. I've created a set of SmartSheets for running construction projects that share data through formula references. How can I make a template set for these sheets so they'll still share data amongst themselves when they're used to create a new project? The only thing I'm seeing in the help files is for saving individual sheets as templates. When I do that, I have to set up all the formula references again in the new set of sheets. This requires an advanced licensed user who understands how these formulas work. I'd like to create a simpler solution. Is Control Center the only way to do this?