Updating Google Sheets when a value is inserted

I have a google sheet and when i type something into the G H I column. it goes to script editor and updates the G H I J and K columns.

This is when i update the sheet manually but when a outside program updates the sheet the formulas dont kick in.

Please see this video [login to view URL]

Does anybody know how to activate the formulas when this happens

Taidot: Google Sheets

Näytä lisää: google sheets send email based on cell value, google sheets find value in range, google sheets script set cell value, google sheets cell value, google sheets get cell value, google sheets custom function not updating, google sheets set cell value, zapier google sheets lookup value, google sheets get value from url, google sheets copy row to another sheet based on cell value, google sheets importrange not updating, google sheets filter based on cell value, google sheets send email when cell value changes, google sheets api search for value, google sheets replace formula with value, google sheets if #value, google sheets find all cells with value, move row based on cell value google sheets, google sheets publish to web not updating, google sheets script get cell value

Projektin tunnus: #29280907