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.
Answers
-
Hi @Dan Heizyk
There currently isn't a way for a rollup sheet to recognize when new sheets are created and need to be added in to the formulas/cell links that you already have established. After creating the new sheet from the template, you'll need to go into your rollup sheets and update them to look at this newly created sheet.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 463 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 40 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!