Update Child Sheet Formulas When Parent Updated

How to update the formulas on Child sheets when the Parent or Template sheet is updated.
Important Notes:
* No script in this video should be ran manually
* The script updating other Sheets files must be set on a trigger
Sheets (Make a copy from the File menu)
Main sheet: docs.google.co...
Secondary sheet: docs.google.co...
Scripts:
function updateExternalChildSheets(e){
const src = e.source.getActiveSheet();
const r = e.range;
if (src.getName() != "Template" || r.getFormula() == "") return;
const sheets = ["1qr2N3dsic67U7KXP3w61vSAV4Hth0MgIa01_dZtEiYE"];
let ss;
for (let i in sheets){
ss = SpreadsheetApp.openById(sheets[i]).getSheets()[0];
ss.getRange(r.getA1Notation()).setFormula(e.value);
}
}
function onEdit(e) {
if (!e) throw "Do not run from Editor";
updateChildSheets(e);
}
function updateChildSheets(e){
const src = e.source.getActiveSheet();
const r = e.range;
if (src.getName() != "Template" || r.getFormula() == "") return;
const sheets = SpreadsheetApp.getActive().getSheets();
let ss;
for (let i in sheets){
ss = sheets[i];
if (ss.getName() == "Template") continue;
ss.getRange(r.getA1Notation()).setFormula(e.value);
}
}
Connect with me:
• [e-mail]
• spencerfarris.me
• www.linkedin.com/in/spencer-farris/
• Twitter @FarrisSpencer
• Google Product Expert support.google.com/docs/profile/12305
Donate on Paypal: [e-mail]

[@TrenerZvezdnaia]

Best!!!

[@kentli8812]

so happy to see you back. Very useful tutorial. Thanks

[@spauldinggg]

Hurray! You’re back!

[@SpencerFarris]

I'm trying to be!

[@sktraders6451]

Glad to see u back. And i appreciate ur spirit to not to sit back. God bless u. 🙏🚩✌

[@SpencerFarris]

Oh He does. Thank you

[@chaos5000]

Welcome back!

[@SpencerFarris]

Thank you! I hope I can be consistent again!

[@jamesgrew9659]

It's great to see you back. Could you also do this with regards to a parent spreadsheet child spreadsheet?

[@SpencerFarris]

The last part of the video shows that, yes!

[@user-mc2el1fi8w]

Great Video! (You typed 0,02 instead of 0,2 for 20%. xD )

[@minimaggot269]

surely you would put the commission rate in a named variable, and link that to the cells.

[@SpencerFarris]

This is dummy data used to illustrate the script. Feel free to use it however you want.