I would like to reference (pull in) formulas (not the result of the formula) from one sheet into multiple sheets so that they calculate on the sheet they are referenced.
For example, if I have
=SUM(Q2:X2) in a formulas sheet, I would like to pull that into 10 other sheets (
budget A sheet,
budget B sheet, etc.) so that it would sum
Q2:X2 for each budget sheet it is referenced into, not the formulas sheet.
I have many budget sheets with the same formulas in the same locations. However, they can change from quarter to quarter. I would like to update the formulas in one place, rather than in each sheet. I think this might be possible with
getFormula, but I'm very new to scripting and not sure how I would use that.