I have a formula in google sheets that requires me to paste it into many cells. It is pretty long and complex, and I’m wondering if there is any way to make it shorter/more efficient for google sheets by either eliminating the pasting across all of the cells using an arrayformula or by using google API query language. Here is the formula: