CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formulagoogle-forms
bradfdlad
bradfdlad

Reputation: 29

How to fix error: 'Array result was not expanded because it would overwrite data in __'

I set up this spreadsheet to take attendance over Zoom each Am with my students. Students fill out a Google Form to check in. Their data goes into a connected spreadsheet, which in turn goes into a sheet displaying student attendance.
Prior to any student data being entered, the cells in rows 3-6 have an error message:

Error: Query completed with an empty output.

Then when a student name populates one of these cells, the following message appears:

Error: Array result was not expanded because it would overwrite data in G3.

What I want to happen is for a student name to be displayed (complete with conditional formatting).

Here's a link to the spreadsheet: https://docs.google.com/spreadsheets/d/1DpERPaq8yIwDKHkp4T463D6GL5WHAVwHAVYqGmHNJxQ/edit?usp=sharing

Upvotes: 0

Views: 50358

Answers (2)

Andy
Andy

Reputation: 11

One of the the I discovered with this #REF error is that if you are looking up by date and have duplicate values of the same date you are looking for in the lookup data, then you will encounter the same error.

Upvotes: 1

marikamitsos
marikamitsos

Reputation: 10573

The syntax of your query should be corrected.

Please use queries using the following pattern:

=query(FormResponses2!D2:G, "select D Where D is not null and D contains 'Anh'")

enter image description here

(Please adjust ranges to your needs)

Functions used:

Upvotes: 5

Related Questions