How can I fix this? I have a large file with over 6000 rows and need to extract specific rows with specific words, couldn’t find anything else, will appreciate any help! "Cannot parse query string for function QUERY parameter 2: COLUMN_ONLY_ONCE: AD"
Hello, im trying to do the same query but with one more "and" like this but it keeps saying "error" =QUERY(basededatos,"SELECT B,C,BJ,N,K,L,AZ,BA,G,F,BK,BI WHERE BH = 'Si' AND BJ >= DATE """&TEXTO(I1,"yyyy-dd-MM")&""" AND BJ
I have a problem regarding this. I have added date range and I want to plot a graph based on months. For example, sale of a product happen in a different dates of different months. But I want to see the accumulated sales considering sales month and represent in graph. I aslo want that month should be selected based on my selected date range. Thanks in advance.
I have a google sheet that I use for inventory that is populated by a google form. When doing ordering I need to only see the most recent entry that was made for all of the records. I'm trying to create a query that show the most recent record entered. How do I do this please. Thank you.
Hello, I tried step by step but my data is still not showing. :( It's not an error just empty. I do not know what is wrong anymore regarding my formula. thank you
thanks for sharing ! I had try to use it in a report but when I select date it would reflect the data of April month in one cell while rest of the month are showing the result as per my report??
Incredibly helpful! Although I'm stumped on how to add more dropdowns. So not only the 2 dates but additional dropdowns IE Opponent and Win/Loss. Any help?
What will the formula be when getting the query from another sheet? I can't get it to work. And does date format matter? E.g. US date format vs EU date format? Thanks.
Wow your formula worked, thanks. How about if you need to filter also the start and end time with the dates? Can you make a video about it with start date&time and end date&time?
Set the "day" to 1, so that it always refers to the first of that month then you can go to format and change to to display May 2023 or Jun 2023 for example. Just remember that the date value is actually May 1, 2023 or Jun 1, 2023
@@hustlesheets I did it! Thanks :D I want to ask one more thing, is this formula can't be used if I overlap the data on the same table? so that I should've separated the main data on another spread or put the main data in an empty space like that?
Bro I mean...I want to pull data for a partcular color by using Query Function....Suppose there are conditioning formatting in sheet if different color...I want to pull data for a color in another sheet automatically
Here's a query FORMULA that works:
=query(StockInfo, "select * where D > date '"&TEXT(DATEVALUE(J15),"yyyy-mm-dd")&"' AND D
I had so much headache trying to solve how to filter using range of date. THANK YOU SO MUCH for this 👍🏼👍🏼👍🏼
Thank you. Very helpful. Exactly what I was looking for my budget view in google sheets. 🙌🏾
How can I fix this? I have a large file with over 6000 rows and need to extract specific rows with specific words, couldn’t find anything else, will appreciate any help!
"Cannot parse query string for function QUERY parameter 2: COLUMN_ONLY_ONCE: AD"
Thanks. It helped me a lot. Greetings from Chile
Thanks! This totally worked Here's the formula --> DATE """&TEXT(A1, "yyyy-MM-dd")&"""
Hello, im trying to do the same query but with one more "and" like this but it keeps saying "error"
=QUERY(basededatos,"SELECT B,C,BJ,N,K,L,AZ,BA,G,F,BK,BI WHERE BH = 'Si' AND BJ >= DATE """&TEXTO(I1,"yyyy-dd-MM")&""" AND BJ
Hi, how can I get K + 30 days using sheets query and K is text(not date) with YYYY-MM-DD,HH:MM:SS format?
AMAZING FORMULA, THANK YOU SO MUCH
But i think Query formula does not work with the real-time change. for that we need to use only google script editor or do we have any other option?
I have a problem regarding this. I have added date range and I want to plot a graph based on months. For example, sale of a product happen in a different dates of different months. But I want to see the accumulated sales considering sales month and represent in graph. I aslo want that month should be selected based on my selected date range. Thanks in advance.
Thanks for your video. I tried for hours to get this results and when I found your page, it was done in 5 minutes !
I had the same damn issue. Ugh!!!
I have a google sheet that I use for inventory that is populated by a google form. When doing ordering I need to only see the most recent entry that was made for all of the records. I'm trying to create a query that show the most recent record entered. How do I do this please. Thank you.
Hello, I tried step by step but my data is still not showing. :( It's not an error just empty. I do not know what is wrong anymore regarding my formula. thank you
thanks for sharing ! I had try to use it in a report but when I select date it would reflect the data of April month in one cell while rest of the month are showing the result as per my report??
But, this formula does not work when the dates are in a row. I tried but everytime it shows, "Formula parse error".
usefull, thansk 4 sharing. Can u open for editable ?
Can i make modified on the query side? I mean once changed it will change the data sheets
How about getting the previous sales from the previous year of the selected month and year?
My google sheets is not recognizing the data format, what should i do?
Always helpful! Thanks!
Incredibly helpful! Although I'm stumped on how to add more dropdowns. So not only the 2 dates but additional dropdowns IE Opponent and Win/Loss. Any help?
Check this section of my dashboard video: ua-cam.com/video/1JkvHfzIL0Y/v-deo.html
Or this: ua-cam.com/video/ccTdDPDGEGM/v-deo.html
What will the formula be when getting the query from another sheet? I can't get it to work. And does date format matter? E.g. US date format vs EU date format? Thanks.
You will use IMPORTRANGE, similar to this video: ua-cam.com/video/7ib-26NgkJo/v-deo.html&ab_channel=Hustlesheets
Date format should not matter
Dear you made my day!
Thanks a lot! You are such a great person.
Nice. I have a list of different companies with different future dates, but only want the most recent date. I'm lost how to pull up just that one.
Wow your formula worked, thanks.
How about if you need to filter also the start and end time with the dates? Can you make a video about it with start date&time and end date&time?
What is the function to just pull the oldest date?
Thank you for sharing!
what if I only want to use 'month' only? without the date and year
I tried to use the same formula but it failed
Set the "day" to 1, so that it always refers to the first of that month
then you can go to format and change to to display May 2023 or Jun 2023 for example. Just remember that the date value is actually May 1, 2023 or Jun 1, 2023
@@hustlesheets I did it! Thanks :D
I want to ask one more thing, is this formula can't be used if I overlap the data on the same table?
so that I should've separated the main data on another spread or put the main data in an empty space like that?
Wow! Working. Thank you so much.
Perfect!
thank you , it is very useful
Thank you so much!
Does anyone know how to do this but with just one date rather than a date range?
It is hard to see in small screen, like smart phones
thank you!it makes my work easier
Great tutorial man 👌
Oh happy day!!!!
Thanks Bro....please also make Video on Query by Color Range
Color range? What do you mean?
Bro I mean...I want to pull data for a partcular color by using Query Function....Suppose there are conditioning formatting in sheet if different color...I want to pull data for a color in another sheet automatically
good
thank you
IT IS NOT WORKING IN MY SHEET
10Q Bro
ang pogi
Share plz formula
Screen to far
Thank you, this really helped me on my report. I use this formula
DATE ' "&TEXT(A1,"yyyy-mm-dd")&" '