u/yesiambear

Got one about to be done. Two others should be about one to two weeks.

Greetings

I am using multiple IMPORTRANGES within a formula to stack datasets. Not very big, about 6 x 1000 rows, and about ten sheets. It had worked just fine until this morning, where now I'm getting a weird #REF error that says mismatched rows, but nothing changed. Another similar set, I'm getting #VALUE

Here is what the formula looks like

FILTER(IMPORTRANGE(......), IMPORTRANGE(.....)<>"")

Is there a known issue with importrange right now?

Thank you!

EDIT - MAN that LET function is cool! Been switching some formulas over and it's working great! Appreciate everyone's assistance!

I was told early on to start with photo seeds. Did so, but now that Ive grow some autos as well, they honestly seem more straightforward. Maybe it's less variables, no idea, but I wish I had started with them to begin with. About to finish a gorilla z auto that might be my best grow to date.

Thoughts? Genuinely curious for discussion. Also what was a big adjustment early on you made to your setup or process that had a huge impact?