This video saved my life. I wanted answers from a specific age bracket only and I was about to go through them INDIVIDUALLY (I have 143 responses to this survey) to find the stats I wanted for my RP. I will forever be in your debt
I’m glad someone typed this out. The video doesn’t magnify the formula as it’s being written and each character is important for this formula to work. I think the content creator could do us all a favor and slow down a bit and and describe each keyboard stroke. Otherwise, without being able to see it on-screen very well, the viewer is left guessing.
Is there a way to query date from more than one column. I can sort names by one column but can not query three. I need to pull the names there column responses as they can be a leader, or helper and need to pull for both on same tab. tried this =QUERY('USE THIS SHEET FOR DATA'!A2:Z, "Select * Where D:F = 'Blair, A'") if is select just D, E or F it pulls data
Thanks, It works really well! But may i know how to modify the formula if we want to get the range from 2 columns? Let's say the "site" has 2 columns (From & To) (Column B & Column C) and we want to get the data that contains "LHS" that comes from column B & C
Jamie, need some help, I have a reservation system and people put in all different dates ie 17 july, 15december, 28 august etc.. at the moment I have them fill out the FORM and when the data comes into the SHEET I would like it to AUTOMATICALLY fall into date order vs doing it manually every time, any suggestions would be highly appreciated (i don't know formulas)..Thanks.
Hi tq for the video, can we filter with a query from a particular time and for a particular date in a timestamp column like it have 2, 3days data so I need to fetch only particular date and time data. Can u help me please?
I have a question, as it seems as if u know sheets.lets say I I have data like Girl and Boy lets say I have someone tagged as girl but they are boy and I change it, how can I make it automatically move to a section on the Same Sheet?
Hi Jamie, Can the data on the sorted sheets (ie, LHS) be updated? I've created a similar sheet using a filter formula for teams to have their own tab of data, but if they need to make updates to the data...it all disappears!!!
Hi Jamie - thank you so much, this is SO helpful. I have just one additional question. How did you get the time and date stamp on there?? I can not figure it out!!
Once you connect your google form to google sheets, anytime the form is submitted, google sheets automatically includes a time stamp. I just realized you asked your question 6 years ago hopefully this helps lol
Jamie, you are giving misinformation. Firstly, you can query the Form Responses 1 Sheet directly. Okay, I do prefer to transfer the Form Responses 1 sheet to another sheet for other reasons. Any way, secondly, you do not use the importrange() function to transfer data from one sheet to another in the same Spreadsheet workbook. Even though it does work it is inefficient. It would be like wanting to give a letter to a family member in the same house but instead of just walking over to them and handing it to them you put a stamp on it and take it to the post office. That will also work but you would not do it because it is inefficient. Hope that makes sense.
Hello Sir, May i know how to modify the formula if we want to get the range from 2 columns? Let's say the "site" has 2 columns (From & To) (Column B & Column C) and we want to get the data that contains "LHS" that comes from column B & C =Query('USE THIS SHEET FOR DATA' !A2:E, "Select * Where B = 'LHS'")
@@SuperVision5 If I am understanding you correctly you are saying column B or column C could have 'LHS' so you want to list all rows that has 'LHS' in column B or C. If that is the case then you can use =Query('USE THIS SHEET FOR DATA' !A2:E, "Select * Where B = 'LHS' or C = 'LHS' ")
@@benliebrand5271 Hi I found your answer in google Help but I have no I dea how to fix it, so could you please explain to me the query() of the filter() function. I have a problem with google sheet not appear when google form responses update and I am very new to excel. Sorry for bothering you and thank you. Ps. I try search youtube and found no helpful information that I can follow through (support.google.com/docs/thread/144087280?hl=en&sjid=11077057188261900266-AP)
Thank you so much, I was literally stuck at spreadsheet for almost 6 hours and almost ended up using multiple spredsheet files.
I have literally been looking for some one to explain this for days. Thank you.
THANK YOU!! you have no idea how much this helped
The best info for solving the challenge of too-long checkbox lines and/or long text options
This video saved my life. I wanted answers from a specific age bracket only and I was about to go through them INDIVIDUALLY (I have 143 responses to this survey) to find the stats I wanted for my RP. I will forever be in your debt
Hi, I also have like 100+ responses for my survey, can I use excel filter instead of this formula and get it according to income level/age/ etc
Hey your formula is not visible .Can you write the same in reply?
When I try it will display it with the query all within one line I’m not sure what my issue is!
This was actually extremely helpful I’m surprised because most of these kinds of videos suck
Is there a way to link separate SHEETS together, as opposed to separate tabs?
how can i input data from above row table? or automatic short data from the new insert data
Love You, Jamie, This is Very Helpful. Thank You!
hi if my data are on going , can we still use these steps?
Hi Jamie. Will this dynamically update with new information?
How to make a chart out of this data?
Thank you, that was helpful and you got right to it, didn't waste my time.
Thank you so much. You are a savior 🙏 🙌
=Query('USE THIS SHEET FOR DATA' !A2:E, "Select * Where B = 'LHS'")
I’m glad someone typed this out. The video doesn’t magnify the formula as it’s being written and each character is important for this formula to work. I think the content creator could do us all a favor and slow down a bit and and describe each keyboard stroke. Otherwise, without being able to see it on-screen very well, the viewer is left guessing.
Really helpful I was looking for the same
I don't know why, I copied your cell the same but still doesn't work
Thanks you saved my life
Is there a way to query date from more than one column. I can sort names by one column but can not query three. I need to pull the names there column responses as they can be a leader, or helper and need to pull for both on same tab. tried this =QUERY('USE THIS SHEET FOR DATA'!A2:Z, "Select * Where D:F = 'Blair, A'") if is select just D, E or F it pulls data
hi about the survey can i seperate the names of the people who take the survey per sheet i hope you understand me sorry for my bad english
Thanks, It works really well!
But may i know how to modify the formula if we want to get the range from 2 columns?
Let's say the "site" has 2 columns (From & To) (Column B & Column C)
and we want to get the data that contains "LHS" that comes from column B & C
Jamie, need some help, I have a reservation system and people put in all different dates ie 17 july, 15december, 28 august etc.. at the moment I have them fill out the FORM and when the data comes into the SHEET I would like it to AUTOMATICALLY fall into date order vs doing it manually every time, any suggestions would be highly appreciated (i don't know formulas)..Thanks.
Hi tq for the video, can we filter with a query from a particular time and for a particular date in a timestamp column like it have 2, 3days data so I need to fetch only particular date and time data. Can u help me please?
how to genrat teport ti excel sheet to thypothisi
The formula u given in comment not working please help
This Video realy helps
I have a question, as it seems as if u know sheets.lets say I I have data like Girl and Boy lets say I have someone tagged as girl but they are boy and I change it, how can I make it automatically move to a section on the Same Sheet?
did not work
Maybe you can change "," with ";"
Does this work the same in excel?
Thank you so so much! This helped me a lot!
THANK YOU SO SO MUCH FOR THIS!
Hi Jamie,
Can the data on the sorted sheets (ie, LHS) be updated? I've created a similar sheet using a filter formula for teams to have their own tab of data, but if they need to make updates to the data...it all disappears!!!
This method just permit you to updating data which is in the first sheet
thanks to this it really helps
Amazing! Thank you!!!
I was wondering does this work with numbers too? I can;t seem to get mine to work
Ya same issue... although I'm replying a bit late ...Do u know now what to do for numbers ?
How to automatically move data from google sheet to another sheet after One hour. Automatically after every one hour.
Hi Jamie - thank you so much, this is SO helpful. I have just one additional question. How did you get the time and date stamp on there?? I can not figure it out!!
Once you connect your google form to google sheets, anytime the form is submitted, google sheets automatically includes a time stamp. I just realized you asked your question 6 years ago hopefully this helps lol
Thank you So Much
Thank you so very much!!!
Jamie, you are giving misinformation. Firstly, you can query the Form Responses 1 Sheet directly. Okay, I do prefer to transfer the Form Responses 1 sheet to another sheet for other reasons. Any way, secondly, you do not use the importrange() function to transfer data from one sheet to another in the same Spreadsheet workbook. Even though it does work it is inefficient. It would be like wanting to give a letter to a family member in the same house but instead of just walking over to them and handing it to them you put a stamp on it and take it to the post office. That will also work but you would not do it because it is inefficient. Hope that makes sense.
Hello Sir,
May i know how to modify the formula if we want to get the range from 2 columns?
Let's say the "site" has 2 columns (From & To) (Column B & Column C)
and we want to get the data that contains "LHS" that comes from column B & C
=Query('USE THIS SHEET FOR DATA' !A2:E, "Select * Where B = 'LHS'")
@@SuperVision5 If I am understanding you correctly you are saying column B or column C could have 'LHS' so you want to list all rows that has 'LHS' in column B or C. If that is the case then you can use =Query('USE THIS SHEET FOR DATA' !A2:E, "Select * Where B = 'LHS' or C = 'LHS' ")
@@benliebrand5271 you got me right, i have tried it and works perfectly as i need.
Thanks a lot for your help Sir
@@SuperVision5 That is great to hear :)
@@benliebrand5271 Hi I found your answer in google Help but I have no I dea how to fix it, so could you please explain to me the query() of the filter() function. I have a problem with google sheet not appear when google form responses update and I am very new to excel. Sorry for bothering you and thank you. Ps. I try search youtube and found no helpful information that I can follow through
(support.google.com/docs/thread/144087280?hl=en&sjid=11077057188261900266-AP)
finally it works!
greet mam