I would like to use list of formula and apply them to certain columns accordingly. Currently throw an error:
Send Expects Scriptable Object in access or evaluation of 'Send' , col << /*###*/Set Formula
Example formula list:
{:Column 7 + 2, :Col1 + 8, :umn 2 * 3, 3, Empty(), Empty(), Empty(), Empty()}
For( i = 1, i < ListSize + 1, i++,
If( i > colSize,
New Column( "temp" )
);//create columns to accomidate list size
col << Set Formula( ms:formulaList[i] );//set column formulas
);