Google Sheet built-in function/custom function order of execution -
my question order of execution between built-in functions , app script functions. there built-in function need executed before rest of app script function(s) executed. what does data copied first range data copied third range validation rule rejects data in third range because doesn't match data of second range (range blank @ stage because built-in function hasn't executed) built-in filter function executes copies required data first range second range. what want do: data copied first range built-in filter function execute , copy required data first range second range copy data third range validation rule accepts in third range because built-in function has populated second range. is there way make happen or google sheets hard wired execute app script functions before built-in functions? the answer was: spreadsheet.app.flush();
