Google Apps Script for Google Sheets Pulling Formulas from Master to Several Slave Sheets

excelroofing

New Member
Joined
Oct 3, 2012
Messages
7
[FONT=&quot]I need help with ONE FORMULA or ONE SMALL SIMPLE SCRIPT in Google Sheets to solve this spreadsheet problem.[/FONT]

[FONT=&quot]I have a master spreadsheet with all my formulas in a row.[/FONT]

[FONT=&quot]I want to have many slave spreadsheets pulling the formulas in via IMPORTRANGE.[/FONT]

[FONT=&quot]So if I need to change a formula I can change it only in the master and it will propagate.[/FONT]

[FONT=&quot]Problem is IMPORTRANGE only imports values. not formulas.[/FONT]

[FONT=&quot]I can import the formulas as text strings without the equal sign from the master to the slave. So now I have a row of all the text of the formulas, but I can't seem to reference those cells to then build the formulas and have Google Sheets recognize them as formulas instead of text strings.[/FONT]

[FONT=&quot]I tried to combine equal sign and the cell with the formula text:[/FONT]

[FONT=&quot]="="&[cell reference with formula as text only without an equal sign][/FONT]

[FONT=&quot]the result is the correct text:[/FONT]

[FONT=&quot]=[my formula][/FONT]

[FONT=&quot]but Google Sheets does not recognize it AS a formula. It is just showing it as text![/FONT]

[FONT=&quot]How can I have a master sheet of formulas to be used in many slave sheets through importrange? Can I do it without a script?[/FONT]
 

Some videos you may like

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

Watch MrExcel Video

Forum statistics

Threads
1,127,145
Messages
5,623,003
Members
415,945
Latest member
Koboca

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top