How do I get formulas from a sheet pointing to a template to work when the template is saved as new?
I've got a template built for a repeating project format and I want to be able to roll up key fields from all of the projects into some combined sheets. The formulas work when populating the original project sheet but when I save as a new sheet, the link breaks.
This is only a problem in breaking the links going from the new project to the combined sheet and not going to the new project sheet.
Help Article Resources
Check out the Formula Handbook template!