Possible to use cell linking for formulas?
I have multiple sheets that are set up in the exact same way, used by various team members. Each sheet has several formulas. If there is an update to the formula, I have to go into each sheet and adjust it. Is it possible to have a reference sheet that houses all the formulas and use some kind of link to reference the cell on the sheet, so when I update the reference sheet the edit is pushed out to all the sheets that use that formula? I tried this, but it seems to just return the result of the formula, not the formula itself. Nor am I able to make this result a column formula. Thanks!
Answers
-
The only way to make something like this work would be to go through the API or possibly a Global Update in Control Center.
-
Ah, I see. Thanks very much, Paul!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!