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.
I've done query right from the response sheet, it's seems to work well. If I add data to the response sheet manually, will it effect the rest of the response sheet?
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.
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 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
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 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?
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!!!
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.
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
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
Love You, Jamie, This is Very Helpful. Thank You!
Thank you So Much
Thank you so much. You are a savior 🙏 🙌
This was actually extremely helpful I’m surprised because most of these kinds of videos suck
Thank you, that was helpful and you got right to it, didn't waste my time.
This Video realy helps
Really helpful I was looking for the same
Thanks you saved my life
Hey your formula is not visible .Can you write the same in reply?
Thank you so so much! This helped me a lot!
THANK YOU SO SO MUCH FOR THIS!
Amazing! Thank you!!!
=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.
I've done query right from the response sheet, it's seems to work well. If I add data to the response sheet manually, will it effect the rest of the response sheet?
how can i input data from above row table? or automatic short data from the new insert data
did not work
Maybe you can change "," with ";"
Is there a way to link separate SHEETS together, as opposed to separate tabs?
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
hi if my data are on going , can we still use these steps?
When I try it will display it with the query all within one line I’m not sure what my issue is!
Thank you so very much!!!
thanks to this it really helps
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.
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 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
How to make a chart out of this 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
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?
I don't know why, I copied your cell the same but still doesn't work
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?
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
finally it works!
how to genrat teport ti excel sheet to thypothisi
Does this work the same in excel?
The formula u given in comment not working please help
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.
greet mam
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)