How do I use this Google Apps Script?

Question

http://code.google.com/googleapps/appsscript/class_range.html#getFormula

Is there a script I can install or do I need to write my own? After that?

Answer 1

Yes, you need to write a google-apps-script that calls that method, is you want to use it.

In your spreadsheet go to Tools->Scripts->Scripts Editor and write your code there.

Of course, the getFormula method simply returns a String representation of the formula in the given cell. Something you can do by just moving the cursor over to that cell. So you don't need to write a script for that.

Answer 2

What would I use to write a formula once and then use it throughout 100 other sheets so that when I change the formula it changes on all sheets?

Thanks!

Answer 3

What would I use to write a formula once and then use it throughout 100 other sheets so that when I change the formula it changes on all sheets?

Thanks!