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.
Ngenye indlela, sakha umsebenzi wokusiza omncane wokwehluka kwesibili okufuna amafomula kulayini 2 wawo wonke amakhasi okusebenza bese siwakopisha ngokuzenzakalela kuze kube sekupheleni kwamatafula. Amafomula ka-ARRAYFORMULA azitshwa ngokuzenzekelayo. Ufaka yonke into ngamathuluzi> Isihleli Sesikripthi bese uyivumela ukuthi isebenze i-1x elawulwa isikhathi ngomzuzu nge- Edit> Trigger yephrojekthi yamanje:
f9c221988a2b56958ffb5b0649bbdf27