Ukuze sandise amafomula kuwo wonke amakholomu ngaphakathi kwe-Google AmaSpredishithi, sincoma ukusebenzisa umsebenzi owusizo we- ARRAYFORMULA . Ngeshwa, lokhu akusebenzi ngokuhlangana neminye imisebenzi ebalulekile efana ne- QUERY noma i- INDIRECT , yingakho kukhona ukuhlelwa okuphelele komqondo kusetshenziswa i- Google Apps Script noma, kungenjalo, ukukopishwa ngesandla kwefomula kuye emgqeni wokugcina.
Njengendlela ehlukile yenketho yesibili, sizodala umsebenzi omncane womsizi osesha amafomula emgqeni 2 wawo wonke amaphepha okusebenzela bese uwakopisha ngokuzenzakalelayo kuze kube sekupheleni kwamaphepha okusebenzela. Amafomula e-ARRAYFORMULA awanakwa ngokuzenzakalelayo. Lo msebenzi ungangezwa nge- Tools > Script Editor futhi uhlelwe ukuthi usebenze kanye ngomzuzu kusetshenziswa i-Edit > Trigger yephrojekthi yamanje.:
f9c221988a2b56958ffb5b0649bbdf27