Formulas In Templates Reference to another Sheet

Bill Herrmann
edited 12/09/19 in Smartsheet Basics

Is there a way to save a sheet as a template that has formula references to another sheet and be able to easily change the reference when using the template? I have a summary and detail sheet that I want to create a template for future use. The summary references the detail. I'd like the Summary sheet to maintain links to the detail. Any suggestions?

 

Thanks in advance. Bill

«1

Comments