u/Cute-Atmosphere2906

Import Range + Flatten Error

I'm trying to create a set of scoresheets - individual judging sheets that get sent to others, and then a master sheet that pulls in all the data from the individual sheets. I would like the rows to be stacked and I'm using this formula

=FLATTEN({IMPORTRANGE("https://docs.google.com/spreadsheets/d/1R\_yJxf1bJOdezIKUXA2SZRdO5ILp6ZBj6Q\_HO7e0OZY", "sheet1!e3:j10"); IMPORTRANGE("https://docs.google.com/spreadsheets/d/1IQW9n4Q3mLvHqVEU7M829s978VvAZxifJFLU2yEUcwM", "sheet1!e3:j10")})

I keep getting the Error message "In ARRAY_LITERAL, an Array Literal was missing values for one or more rows." - and I'm not sure why, the two sheets I'm pulling from are formatted exactly the same. Happy to provide more information as needed!

reddit.com
u/Cute-Atmosphere2906 — 15 days ago