0

I want to use a formula in multiple sheets. for example:

I have a sheet named "Formulas" and in cell "A1", There is a text "B1+B2"
Now, I want to run this formula in Sheet1 and Sheet2.
So, If I Edit "Formulas!A1" to "B1+B2+B3", in all sheets, results change.

Improve this question
1
  • Welcome. Please remember that as per site guidelines when an answer addresses your question, you should accept it so others can benefit as well.
    – marikamitsos
    Commented Jan 31, 2020 at 16:35

2 Answers 2

Reset to default
0

To update the formulas of different sheets, like Sheet1 and Sheet2 when a formula is edited in a third sheet, like Formulas, then you should use Google Apps Script including an on edit trigger.

The above because Google Sheets doesn't include a built-in feature that does that. An alternative to write the script by yourself is to use and add-on. You could look for existing add-ons in the G Suite Marketplace

References

Improve this answer
0

What you need is the IMPORTRANGE function.

The result will be exactly what you expect:

So, If I Edit "Formulas!A1" to "B1+B2+B3", in all sheets, results change

Note: In order to make the function work you will be asked to "link" the sheets. Just go ahead and accept it.

Improve this answer
1

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.