Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

I want to write a formula once in one sheet and have others call that formula and do calculation in their own sheet. I want to do this because calculations need to be done in 100 other sheets within the same document but I dont want to have the change the formula in everyone of those sheets if we decide to modify it.


share|improve this question
Do you mean other sheets within the same document or across different documents? –  ChrisF Oct 7 '10 at 20:59
Within the same document. –  dotLoom Oct 7 '10 at 21:17
In Excel to refer to a cell in another sheet you use: =Sheet1!B7 (for example) but I'm not sure how this helps you in your case. –  ChrisF Oct 7 '10 at 21:29
Doing that doesn't bring the formula over it brings the value over. –  dotLoom Oct 7 '10 at 21:30
If you associate your Web Apps and Super User accounts you'll regain ownership of the original question. –  ChrisF Oct 8 '10 at 22:27

1 Answer 1

Excel doesn't have a built-in to return the formula, you will have to use this user defined function.

share|improve this answer
Does anything like this exist for Google Docs? –  dotLoom Oct 7 '10 at 22:39
No, Nothing built in or user defined, you'll have to build a script –  Sathya Oct 7 '10 at 23:03
I was trying to build a custom function =CopyFormula() but it the scripting API forbids us developers from grabbing data from any cell other than the current active cell when using custom functions, so I doubt this will be possible in Google Docs –  Sathya Oct 8 '10 at 0:44
Thanks for trying. How do I use this? code.google.com/googleapps/appsscript/… –  dotLoom Oct 8 '10 at 3:10
@dotLoom This is what I had came up with, while trying to create that custom formula pastebin.com/qVcgBufV –  Sathya Oct 8 '10 at 3:21

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.