Ukwandisa iifomyula kuzo zonke iikholamu ngaphakathi kwaMashidi kaGoogle, sincoma ukusebenzisa umsebenzi oluncedo we-ARRAYFORMULA . Ngelishwa, oku akusebenzi ngokudityaniswa neminye imisebenzi ebalulekileyo efana ne -QUERY okanye INDIRECT , yiyo loo nto kufuneka wenze ingqiqo ngokupheleleyo usebenzisa i-Google Apps Script okanye, ngokunye, ukhuphele ifomula ngesandla ukuya kumgca wokugqibela.
Njengendlela eyahlukileyo yokhetho lwesibini, siza kudala umsebenzi omncinci womncedisi okhangela iifomyula kumqolo wesi-2 wazo zonke ii-worksheets kwaye uzikopishe ngokuzenzekelayo ukuya ekupheleni kwee-worksheets. Iifomyula ze-ARRAYFORMULA azinakwa ngokuzenzekelayo. Lo msebenzi ungongezwa nge -Tools > Script Editor kwaye ucwangciselwe ukusebenza kube kanye ngomzuzu kusetyenziswa i-Edit > Trigger yeprojekthi yangoku.:
f9c221988a2b56958ffb5b0649bbdf27