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

[excelroofing]

[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]

 

[Macropod]

Cross-posted at: https://www.excelforum.com/for-othe...ulas-from-master-to-several-slave-sheets.html

Please read Mr Excel's policy on Cross-Posting in rule 13: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html

 

[excelroofing]

Here are links to the 2 example spreadsheets:


https://docs.google.com/spreadsheets/d/1txdbZPfzciSQYfmnuK9-Hn0CxM44El1-mJBTa3kOGvs/edit?usp=sharing


https://docs.google.com/spreadsheets/d/1_osxW2zp-Q2XuyUlU9b707s557HXfRvrgPTXBOGpiPA/edit?usp=sharing