Bumped by Community user

occurred Dec 24, 2018 at 6:02

Bumped by Community user

occurred Nov 24, 2018 at 6:00

added 3 characters in body; edited tags

Source Link

edited Oct 25, 2018 at 5:16

I'm trying to run a Query on some data thatsthat's being imported, and have it only Bring data over that matches the Email in the document.

This is my code:

=QUERY(IMPORTRANGE("SHEET ID REMOVED","'Form Responses 1'!$A$1:$O"),"SElECT * WHERE Col15 = 'TEST'",1)

Where it says TEST, I have a Script that pulls the Email, and places it in =YTD!B21=YTD!B21

How can I get the Query to Import only the ranges that have the Attached Email?

I'm trying to run a Query on some data thats being imported, and have it only Bring data over that matches the Email in the document.

This is my code:

=QUERY(IMPORTRANGE("SHEET ID REMOVED","'Form Responses 1'!$A$1:$O"),"SElECT * WHERE Col15 = 'TEST'",1)

Where it says TEST, I have a Script that pulls the Email, and places it in =YTD!B21

How can I get the Query to Import only the ranges that have the Attached Email?

I'm trying to run a Query on some data that's being imported, and have it only Bring data over that matches the Email in the document.

This is my code:

=QUERY(IMPORTRANGE("SHEET ID REMOVED","'Form Responses 1'!$A$1:$O"),"SElECT * WHERE Col15 = 'TEST'",1)

Where it says TEST, I have a Script that pulls the Email, and places it in =YTD!B21

How can I get the Query to Import only the ranges that have the Attached Email?

Source Link

asked Oct 24, 2018 at 20:05

Google Sheets Query Searching?

I'm trying to run a Query on some data thats being imported, and have it only Bring data over that matches the Email in the document.

This is my code:

=QUERY(IMPORTRANGE("SHEET ID REMOVED","'Form Responses 1'!$A$1:$O"),"SElECT * WHERE Col15 = 'TEST'",1)

Where it says TEST, I have a Script that pulls the Email, and places it in =YTD!B21

How can I get the Query to Import only the ranges that have the Attached Email?

Return to Question