Excellent tutorial. Can you tell me how can I link this dynamic data pulled from outside my current sheet with the static data that I am entering corresponding to it? So that when there is a new addition to the data there is no mismatch with the static rows.
What i have been looking for! The only cells that did not import for me was the very top frozen row with the column categories. Do you know why this happens? Thanks!
Brilliant!! After failing with so many other tutorial I get this to work following your video. Now... How can I do this within the same file landing in a different tab(sheet). I would like Sheet1 to be SourceData and Sheet2 the Imported/Filtered Data
Good evening, First of all thank for this awesome video! I learn how to do the importrange and combined it with a query from another video to add a filter on it. I am working in logistics in a production environment and making a tab to check each production status. For instance a tab with "Nesting" when they are collecting the materials. This will come in the "nesting" tab. But during a weekly follow-up meeting I add comments in a column next to the import range. When the "nesting" than is being put on "finished product" the imported line dissapears (which is my intention), but the comment I wrote myself just stays in the same cell and thus is 'transferred' or 'linked' to the "nesting" row below. When a status changes and dissapears how can I also let the comment dissapear with it? Is this possible? Thanks in advance!
I was constantly getting the mismatched error before using INDEX in FILTER. Now when I am done sorting that, there is another error - "No matches are found in the filter evaluation". I have done multiple checks for the source data, my target sheet, column I am trying to pull. All seem to be fine but the function is not working again. Can you help here , please ! :|
Hi, is it possible to use the filter formula in one column only and filter more than one value? For example, in your video, you filtered "Graduate", is it possible to filter "Graduate" and "Uneducated"? Hope you'll respond to my question. Thanks!
Reference to a cell where you have added a data validation of all possible filter item you need for example, Make a cell (say T1) resultant to a data validation for Graduate, Undergraduate, College etc. replace the cell number in place of "Graduate" to T1 with the Open/closed parenthesis and you only need to tweak your validation to the filter you wish to see.
Thank you for this video. I'm trying to use this same method using date range from multiple columns. I feel like I'm close but am getting parenthesis error.. Any ideas what I'm doing wrong? Thanks! =QUERY(IMPORTRANGE("google_sheet_url/","CLUBSMASTER!A:H"),"select Col1,Col2,Col3,Col4,Col5,Col6,Col7,Col8 where Col6 = date '"&TEXT(B1, "yyyy-mm-dd")&"'", 1) OR Col7 = date '"&TEXT(B1, "yyyy-mm-dd")&"'", 1) OR Col8 = date '"&TEXT(B1, "yyyy-mm-dd")&"'", 1)
Searching this video from so long. Thanks for support!
You're welcome!
Thank you. Easy to understand. I learnt a lot from your tutorials. Have incorporated to my work.
I was having so much trouble finding a good tutorial for this- this video is great!
Excellent information. Exactly what I needed. Clear and concise. Thanks!
very very very useful video, Thanks a lot man !!
I needed this. Thanks.
THANK YOU
Thanks for the video Work Perfectly, Looking forward For More videos
Man, love u so much for this
Very nice... Thank you very much!...
Thank you this proved very helpful
many thanks
Excellent tutorial. Can you tell me how can I link this dynamic data pulled from outside my current sheet with the static data that I am entering corresponding to it? So that when there is a new addition to the data there is no mismatch with the static rows.
Great video❤
What i have been looking for! The only cells that did not import for me was the very top frozen row with the column categories. Do you know why this happens? Thanks!
how to make exception filter, ex show data except graduate?
MANY THANKS INDEED BROH!
This is really helpful
Brilliant!! After failing with so many other tutorial I get this to work following your video.
Now... How can I do this within the same file landing in a different tab(sheet). I would like Sheet1 to be SourceData and Sheet2 the Imported/Filtered Data
How sort by date
Thanks a Ton
Good evening,
First of all thank for this awesome video! I learn how to do the importrange and combined it with a query from another video to add a filter on it.
I am working in logistics in a production environment and making a tab to check each production status. For instance a tab with "Nesting" when they are collecting the materials. This will come in the "nesting" tab. But during a weekly follow-up meeting I add comments in a column next to the import range. When the "nesting" than is being put on "finished product" the imported line dissapears (which is my intention), but the comment I wrote myself just stays in the same cell and thus is 'transferred' or 'linked' to the "nesting" row below. When a status changes and dissapears how can I also let the comment dissapear with it? Is this possible?
Thanks in advance!
QUERY function wont pull text if columns contain numbers
any alternate solution ?
I was constantly getting the mismatched error before using INDEX in FILTER. Now when I am done sorting that, there is another error - "No matches are found in the filter evaluation". I have done multiple checks for the source data, my target sheet, column I am trying to pull. All seem to be fine but the function is not working again. Can you help here , please ! :|
I would take a look to make sure the data in both source and target sheets don't have extra spaces at the beginning or end of the values.
Hi...what the furmula is for more than 1 spreadsheet/file
Hi, is it possible to use the filter formula in one column only and filter more than one value? For example, in your video, you filtered "Graduate", is it possible to filter "Graduate" and "Uneducated"? Hope you'll respond to my question. Thanks!
I believe it's possible!
@@Thekeycuts I tried it but it's not working. Do you think you can teach us that?
@@Thekeycuts The same issue, how would you do that?
Reference to a cell where you have added a data validation of all possible filter item you need for example, Make a cell (say T1) resultant to a data validation for Graduate, Undergraduate, College etc. replace the cell number in place of "Graduate" to T1 with the Open/closed parenthesis and you only need to tweak your validation to the filter you wish to see.
Result too large error showing during running formulas pls resolve the issue
Is it possible to make your filter variables ("Graduate") flexible? F.e. when filter variable = found in a list (with a VLOOKUP)? Great video btw!
Help! When I use query function I am getting an error #value! "No_COLUMN: col1" but my source sheet does have a column 1, etc.
You may want to check the spreadsheet ID is correct in your source Google Sheet
I am getting the same thing. My spreadsheet ID is correct. Did you figure it out @Anya Bartlett?
cool
Copy the Google Sheet: Source - docs.google.com/spreadsheets/... Target - thnx you !!!👍
Thank you for this video. I'm trying to use this same method using date range from multiple columns. I feel like I'm close but am getting parenthesis error.. Any ideas what I'm doing wrong? Thanks!
=QUERY(IMPORTRANGE("google_sheet_url/","CLUBSMASTER!A:H"),"select Col1,Col2,Col3,Col4,Col5,Col6,Col7,Col8 where Col6 = date '"&TEXT(B1, "yyyy-mm-dd")&"'", 1) OR Col7 = date '"&TEXT(B1, "yyyy-mm-dd")&"'", 1) OR Col8 = date '"&TEXT(B1, "yyyy-mm-dd")&"'", 1)