Array Result Not Expanded Because it would overwrite data
I have a very complex google form I use for my daily business. From the response sheet I create separate tabs that are filtered using a Query function. I create a separate sheet for each of these filtered tabs using the importrange function and then run the document studio add-on to create the google doc that is mail merged.
When I add questions to my google form it expands the columns. When I do this it gives me the “array result not expanded because it would overwrite data”
How do I fix this? I am sure it wont be the last time I need to adjust my google form. Thanks for the help!