Skip to main content
Web Applications

Return to Question

Became Hot Network Question
deleted 32 characters in body; edited tags; edited title
Source Link
Rubén - Volunteer Moderator - ♦
Rubén - Volunteer Moderator - ♦
  • 46.1k
  • 18
  • 100
  • 297

Import Range ImportRange Query Formatted Incorrectly

I have a spreadsheet that I want to pull data from another spreadsheet.
This is my formula:

=query(importrange("https://docs.google.com/spreadsheets/d/14lj6yPp8h9U1JAEA4dz-uROaQgZxy60NjXniHOFUeAU/edit#gid=0", "TRANSACTIONS!B6:P9999"), "select Col2, Col3, Col13, Col14, Col15, Col16 where Col16='EV' and Col2>=date '"&to_text("2024-04-01")&"' AND Col2<date '"&to_text("2024-05-01")&"'", 0)=query(importrange("https://docs.google.com/spreadsheets/d/14lj6yPp8h9U1JAEA4dz-uROaQgZxy60NjXniHOFUeAU/edit#gid=0", "TRANSACTIONS!B6:P9999"), "select Col2, Col3, Col13, Col14, Col15, Col16 where Col16='EV' and Col2>=date '"&to_text("2024-04-01")&"' AND Col2<date '"&to_text("2024-05-01")&"'", 0)

This is the error I am receiving: Error Unable to parse query string for Function QUERY parameter 2: NO_COLUMN: Col16

Error
Unable to parse query string for Function QUERY parameter 2: NO_COLUMN: Col16

What am I doing wrong? Any help would be appreciated. Thank you!

Import Range Query Formatted Incorrectly

I have a spreadsheet that I want to pull data from another spreadsheet.
This is my formula:

=query(importrange("https://docs.google.com/spreadsheets/d/14lj6yPp8h9U1JAEA4dz-uROaQgZxy60NjXniHOFUeAU/edit#gid=0", "TRANSACTIONS!B6:P9999"), "select Col2, Col3, Col13, Col14, Col15, Col16 where Col16='EV' and Col2>=date '"&to_text("2024-04-01")&"' AND Col2<date '"&to_text("2024-05-01")&"'", 0)

This is the error I am receiving: Error Unable to parse query string for Function QUERY parameter 2: NO_COLUMN: Col16

What am I doing wrong? Any help would be appreciated. Thank you!

ImportRange Query Formatted Incorrectly

I have a spreadsheet that I want to pull data from another spreadsheet.
This is my formula:

=query(importrange("https://docs.google.com/spreadsheets/d/14lj6yPp8h9U1JAEA4dz-uROaQgZxy60NjXniHOFUeAU/edit#gid=0", "TRANSACTIONS!B6:P9999"), "select Col2, Col3, Col13, Col14, Col15, Col16 where Col16='EV' and Col2>=date '"&to_text("2024-04-01")&"' AND Col2<date '"&to_text("2024-05-01")&"'", 0)

This is the error I am receiving:

Error
Unable to parse query string for Function QUERY parameter 2: NO_COLUMN: Col16

What am I doing wrong?

Source Link
Salt_Tea
Salt_Tea
  • 31
  • 3

Import Range Query Formatted Incorrectly

I have a spreadsheet that I want to pull data from another spreadsheet.
This is my formula:

=query(importrange("https://docs.google.com/spreadsheets/d/14lj6yPp8h9U1JAEA4dz-uROaQgZxy60NjXniHOFUeAU/edit#gid=0", "TRANSACTIONS!B6:P9999"), "select Col2, Col3, Col13, Col14, Col15, Col16 where Col16='EV' and Col2>=date '"&to_text("2024-04-01")&"' AND Col2<date '"&to_text("2024-05-01")&"'", 0)

This is the error I am receiving: Error Unable to parse query string for Function QUERY parameter 2: NO_COLUMN: Col16

What am I doing wrong? Any help would be appreciated. Thank you!