Skip to main content
Web Applications

Return to Question

deleted 65 characters in body; edited title
Source Link
pnuts
pnuts
  • 17.8k
  • 5
  • 54
  • 103

Is it possible to import a formula from another Spreadsheet in google Sheetsspreadsheet?

the question is simple: II have a master Spreadsheetspreadsheet, call it Master, and a lot of copies of this Spredsheetspreadsheet, one for every person in my organization, because they need theyrtheir own copy. The The Master sheet havehas a lot of formulas. I want to know if

Is it is possible to update a formula in the Master, and reflect the update on all the "sons" spreadsheet,spreadsheets without editing everyone (like ImportRange but with formulas and not values).?

PS: isIs the same possible also for the script sheet?

Many thanks Manuel

Is it possible to import a formula from another Spreadsheet in google Sheets?

the question is simple: I have a master Spreadsheet, call it Master, and a lot of copies of this Spredsheet, one for every person in my organization, because they need theyr own copy. The Master sheet have a lot of formulas. I want to know if it is possible to update a formula in the Master, and reflect the update on all the "sons" spreadsheet, without editing everyone (like ImportRange but with formulas and not values).

PS: is the same possible also for the script sheet?

Many thanks Manuel

Is it possible to import a formula from another spreadsheet?

I have a master spreadsheet, call it Master, and a lot of copies of this spreadsheet, one for every person in my organization, because they need their own copy. The Master sheet has a lot of formulas.

Is it possible to update a formula in the Master, and reflect the update on all the "sons" spreadsheets without editing everyone (like ImportRange but with formulas and not values)?

PS: Is the same possible also for the script sheet?

Source Link
Manuel Dal Bianco
Manuel Dal Bianco
  • 1
  • 1

Is it possible to import a formula from another Spreadsheet in google Sheets?

the question is simple: I have a master Spreadsheet, call it Master, and a lot of copies of this Spredsheet, one for every person in my organization, because they need theyr own copy. The Master sheet have a lot of formulas. I want to know if it is possible to update a formula in the Master, and reflect the update on all the "sons" spreadsheet, without editing everyone (like ImportRange but with formulas and not values).

PS: is the same possible also for the script sheet?

Many thanks Manuel