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