Ukuze unwebe amafomula kuwo wonke amakholomu ngaphakathi kwe-Google AmaSpredishithi, sincoma ukusebenzisa umsebenzi owusizo we-ARRAYFORMULA . Ngeshwa, lokhu akusebenzi ngokuhambisana neminye imisebenzi ebalulekile efana ne -QUERY noma i-INDIRECT , yingakho kufanele wenze umqondo ngendlela oyifisayo usebenzisa i-Google Apps Script noma, ngokunye, ukopishe ifomula ngokwakho uze ufike emugqeni 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