How to move 2nd array formula in the same column if the 1st array has a spill error in google sheets?

Mike P 0
Viewed 24

I have two array formulas that repeat dates n number of times in the same column. Both of them could be dynamic so the 1st array could extend into the territory where the other array is currently causing a split error.

My question is there a way to write this array formula as one formula? Or is there some other method by which this can be done?

enter image description here

google-sheets-formula google-sheets google-apps-script
1 Answers

A very simple way, given what I can see in your screenshots would be to contain both query formulas within another array formula and separate them with a semi-colon. This will stack them vertically. Essentially, it should look something like this:

=ARRAYFORMULA({QUERY1;QUERY2})
LASheets0
Related