i guess Im asking the wrong place but does someone know of a way to log back into an instagram account? I somehow forgot the account password. I love any assistance you can offer me
@Ishaan Jayce I really appreciate your reply. I got to the site on google and Im trying it out atm. Looks like it's gonna take quite some time so I will get back to you later when my account password hopefully is recovered.
Thank you so much! For an internship interview I had to visualize data in Google sheets while I never used Google sheets before (only excel). They were really impressed by my dashboard! I really wanted this internship and without your videos I do not think I would get the internship! So, thank you so much and keep up the good work :)
This is nice! Just a tip if you want to change something in the formula and not have to worry whether you changed it or not, use the find and replace tool on the selected cell and tick the "within formulas" box and you should be able to replace everything without any problems.
I have watched this video last year, at that time I didn't understand and this week I watch this tutorial again almost everyday. Thank you very much, I have been searching the right formula for my report, and now I know how to use Query formula into my report. Thank you very much for helping me. It means a lot for me.
Hi Hustlesheets, I completed a formula using a line and a common fixed location (e.g c2). When I dragged the curser down the page, the 50 lines all came up with an incorrect or no answer at all. Then it occurred to me, if I place the common figure on each of the 50 lines, then from the top, line drag the cursor down, and this then worked. Phew!!!! I made it in the end. Really appreciate all your help which kept me going. Great video too. Thank you again.
Excellent example of a great Sheets-based dashboard -- and one of the more useful practical examples of how to use the QUERY function that beginners can connect with. Thanks for creating the video!
Hi Sir you are a Lifesaver I haven’t properly taken the time to reply. Because of your work I was able to do my job. It means a lot and thank you 🙏 for your hard work. Appreciate you very much sir. Sincerely
Thank you so much for sharing! I'm in software and I even have trouble following other tutorials out there, but using the Query command makes it so much easier and loads more powerful!
31:37 Bless you! Really like how Sheets refreshes the data by its own, you don't need to push refresh button every time like in Excel We definitely need the in-depth know-how for analogue of Excel slicers in Google Sheets. I will check your channel hoping you already made something like this.
Wow what can I say, I have been looking for a way to do formula for age, this video is really great to follow, I'm 69 yrs old and still learning, just shows you are never too old to learn.
@@hustlesheets Mhmm, is there anything for a dash specifically tracking marketing only, that I could put together? I opened a business last year and I’m trying to really cracks down on it.
I'll be releasing a full scale paid dashboard course soon! Signup if you want early access (will be limited to x amount of students): forms.gle/iPPQtHjP4GF6ukgAA
Hey! This video is super helpful for someone as technologically inept as myself :D i did the Query formula in the beginning, but I don’t have the first row as the name of whatever it is for like yours does. I’m working with something not even remotely sales related mind you, so could be that i didn’t use it right… :(
Love this video. Very nice intro to Query formula. You did not cover the pivot part of this though. Maybe in your next video. You did touch upon a little with the helper columns for Month/Year etc. Can query replace Pivot functions? I think it can, but would like to hear from you. Thanks for sharing.
I love it! You know your stuff! Great!!! :-) really easy to follow even when you are going on the express line! Beautiful! If you have any way to include my name in a distribution list... I’ll be ready to watch it and give you any direct feedback! Namaste!
Oh cool! Basically it supports SQL for the QUERY language. Thanks for the video o/ Edit: It's really a shame that they use LABEL instead of the SQL way of "SELECT sum(A) as Total..."
The range options for DV are no longer available in google Sheets, we have manually mentioned the options in the side bar. Is there a solution to this?
Hello Michael. I have created a dashboard similar to yours (thanks to you and this amazing tutorial) with a dropdown list of products and I was wondering whether you can add notes in the dashboard view (not in the raw data sheet)? So If I write a note for a product called "x" and then you change the selection on the dropdown those notes will correspond to the dropdown selected item "x" only and so on. Can it be done? I hope it makes sense.
How would I get closing rate? I separate my sales person closing rate by the type of lead it is, Self-Generated, Marketed, Turnover or Referral... I want to see the closing rate for each category, how can I make this happen?
Hey is there anyway I can add more features to this especially inventory and goalsetting and place of work in here like my best sellers and stuff like that thank you please let me know ASAP
Hi I truly love this video and watched it literally from start to finish three times (not including multiple replays of some sections), and I did build a dashboard using our org's own data! This is extremely helpful. And now i am watching your video on dynamic dashboard using query formula and dropdown lists. Just really want to thank you for this intuitive course.
@@hustlesheets Hi, thank you so much for reaching out! actually i am curious if you can do video tutorials on more advanced query functions and incorporate those into a real-world example (like sales dashboard)?
I just want to share that your approach in teaching is very organized and friendly. I personally dread learning sheets in the past but I truly learned so much from this video. I hope you keep on teaching. Thank you so much for sharing your expertise. :) :)
COUNT(DISTINCT To avoid empty cells. .... Overall, someone would have to understand basic SQL first to understand "query language"; no other way. Nice video though.
Thanks for the video. Now, I have an understanding of developing dashboards on Google sheets. However, pls is it possible to get the data you used, so I can practice exactly what you did. This is my first time using Google Sheets
I have used this =QUERY(MASTER!F2:X82,"select V, N, sum (W) group by V,N") but how do i also ask it to do similar to also add in another column the results of column (X)
hey, im using a url fetch and dont want to have to copy the url from the webpage every time for a specific term. is there a way i can have it autopoluate the address if its the same minus the /bitcoin/ term? say i want the next one to autopopulate the url from to =IMPORTXML("coinmarketcap.com/currencies/bitcoin/","//div[@class='priceValue___11gHJ']") to =IMPORTXML("coinmarketcap.com/currencies/ethereum/","//div[@class='priceValue___11gHJ']") based on my parameters
Hey Michael, I'm trying to do within below query formula a difference between two dates and present it in another column =QUERY('Raw Data'!A1:U, " SELECT J, MAX(U), SUM(L), '" & TEXT(TODAY(), "mm/dd/yyyy") & "' WHERE J '' GROUP BY J LABEL MAX(U) 'Date', SUM(L) 'Qty', '" & TEXT(TODAY(), "mm/dd/yyyy") & "' 'Today' ", 1) Can you help me do this since I'm getting errors?
@hustlesheets such a great tutorial! But... I have written the first QUERY-formula exactely as you have, but with another DATA sheet and i get #ERROR. I have tried several things like changing formula language, I have made sure that columns have the right format, change "," to ";" (like in excel) and back again etc. but nothing works. Does anyone have a clue and can help me?
This is highly valuable info, thanks for taking time to create. Very interested in a deeper dive video/ course… I wouldn’t hesitate spending $20-30 one time for the info, FYI.
Hi There thanks for the great vid. 1 question this far into it. In the dropdowns, for the list of sale people, you included a "New Name" at bottom of the referenced list... My question is, how does that work when actually inputting new data? If i select "New Name" is that a "protected term" in google? That it will then know whatever name i type in there is TO BE ADDED to the originally referenced main dropdown list? Or does it just allow type over for that field that generates a validation error, and the new name would ultimately need to be manually added to the dropdown list still? Don't know if that makes sense or not...
Thank you for sharing this tutorial. I'm new to creating spreadsheets. I'd like to know if the same formulas work on Excel too? If they don't, do you have a tutorial for excel? Thanks!
im using sheets for gaming and my clan. i have 500 members, the only problem im having with sheets r the dates WONT stick to their names for some reason. dates keep changing, any reason why?
Thank you very much for your reply. I just keep getting an error. It does not ($) work. I'm going to have to manually input 50 lines with their individual formula's. I have had this before. Sometimes the drag works and sometimes it does not. Great Video. Thank you again.
I keep trying the step at 5:59 selecting data range and Sheets just keeps making the dropdown apply to the Dropdown Menus list, not on the column selected in the Sales Data. Also Sheets looks a bit different now 2 years later so I'm wondering if there is a new step for using a Drupdown menu page to pull from.
hi michael, do u have a video where to measure the handling time of an email? let say u have 5 members handling emails and on the 1st tab ~this is the place where the members will put the information like the there's a counter for date, name, dept, query (log ins, purchase, password reset) this page is only shown to members and very friendly user page. members will have their own tabs. and there will be a counteres for all information that they have entered on each of their tabs. on their tabs -we can only provide necessary information and there will no way that they can enter unaccetble data/info that will greatly affect to the master file? Is there also away that the masterfile will be protected even if each member's tab made an error or unacceptable data? what I meant is the masterfile for reporting purposes can be harmed or when we look it there will still be information or data on it, meaning it will not be damaged or deleted or edit or manipulated or something.... sorry for the long message, hope u can help me thank you so much
Hi! Question, in one account you have 3 Sales Rep and they will divide the Sales amount equally how do you proceed in query. Hope you will notice this one. Thank you
Hi! Question, in one account you have 3 Sales Rep and they will divide the Sales amount equally how do you proceed in query. Hope you will notice this one. Thank you
How to create date and text filters using QUERY formula: ua-cam.com/video/XGvCT3IeYdA/v-deo.html&ab_channel=Hustlesheets
i guess Im asking the wrong place but does someone know of a way to log back into an instagram account?
I somehow forgot the account password. I love any assistance you can offer me
@Callan Alexis instablaster ;)
@Ishaan Jayce I really appreciate your reply. I got to the site on google and Im trying it out atm.
Looks like it's gonna take quite some time so I will get back to you later when my account password hopefully is recovered.
@Ishaan Jayce It worked and I now got access to my account again. Im so happy!
Thank you so much you really help me out :D
@Callan Alexis happy to help =)
Thank you so much! For an internship interview I had to visualize data in Google sheets while I never used Google sheets before (only excel). They were really impressed by my dashboard! I really wanted this internship and without your videos I do not think I would get the internship! So, thank you so much and keep up the good work :)
This is great to hear! A year later lol, but is there anything else you would like to learn about Google Sheets?
This is nice! Just a tip if you want to change something in the formula and not have to worry whether you changed it or not, use the find and replace tool on the selected cell and tick the "within formulas" box and you should be able to replace everything without any problems.
I have watched this video last year, at that time I didn't understand and this week I watch this tutorial again almost everyday. Thank you very much, I have been searching the right formula for my report, and now I know how to use Query formula into my report. Thank you very much for helping me. It means a lot for me.
This is an awesome resource. I have come back to it several times for help! Thank you.
Hi Hustlesheets, I completed a formula using a line and a common fixed location (e.g c2). When I dragged the curser down the page, the 50 lines all came up with an incorrect or no answer at all. Then it occurred to me, if I place the common figure on each of the 50 lines, then from the top, line drag the cursor down, and this then worked. Phew!!!! I made it in the end. Really appreciate all your help which kept me going. Great video too. Thank you again.
This is one of the most informative videos I have ever seen on UA-cam. Thank you for the knowledge, it really helped a lot
Excellent example of a great Sheets-based dashboard -- and one of the more useful practical examples of how to use the QUERY function that beginners can connect with. Thanks for creating the video!
T shoulder without a bottom handle? 😭 this the same shoulders which held the Abu Ghraib costume
Thank you for this video. I just finished creating my first dashboard at work and used your video as a guide. Thanks again.
Simply excellent content, and instruction. One of the best I've seen and the query is so powerful! My new go-to for G-Sheets problem solving!
Just want to say thank you for creating this content. You are helping so many people! Appreciated!!!
Hey man, great stuff. I've looked for a video like this for sheets for months. This is awesome.
You're a good man for sharing this. Thank you.
Hi Sir you are a Lifesaver I haven’t properly taken the time to reply. Because of your work I was able to do my job. It means a lot and thank you 🙏 for your hard work. Appreciate you very much sir. Sincerely
Thank you so much for sharing! I'm in software and I even have trouble following other tutorials out there, but using the Query command makes it so much easier and loads more powerful!
Hello there! I love your content. Direct to the point in teaching. Continur doing this! -from Philippines
I'm going to be spending hours analyzing this for implementation into my daily tasks.
SUBSCRIBED! This is GOLD man. Thank you for breaking this down so cleanly! Cheers man.
Google sheets supports pseudo SQL queries?!! You opened so many possibilities for me, thank you so much
Only problem with yt is you find the best content in the last .
31:37 Bless you!
Really like how Sheets refreshes the data by its own, you don't need to push refresh button every time like in Excel
We definitely need the in-depth know-how for analogue of Excel slicers in Google Sheets. I will check your channel hoping you already made something like this.
I really appreciate this video - have been trying to find a way to create a dashboard and this made it really clear!
Wow what can I say, I have been looking for a way to do formula for age, this video is really great to follow, I'm 69 yrs old and still learning, just shows you are never too old to learn.
Wow! That's awesome! Thank you for watching
Mad these vidoes slap.Definetly inspired me to take me spreadsheet game up.
Great tutorial. I was interested in Pivot tables within queries
Thank you very much for the presentation, Michael! It helped me a lot!
Excellent tut, thank you so much for the time you spend and all the knowledge you share !
Very informative. Thanks for breaking down
You really deserve more views, this is a great tutorial. Knowledgeable, clean, and very handy. Thank you for your time doing this.
Thank you, I think so too :)) haha. Is there anything else you'd like to learn in Google Sheets?
Thank you a bunch for teaching me how to put this together!
Of course! Is there anything else you'd like to learn in Google Sheets?
@@hustlesheets Mhmm, is there anything for a dash specifically tracking marketing only, that I could put together? I opened a business last year and I’m trying to really cracks down on it.
well explained and structured approach. Thanks and keep it up.
Great explanations. Well done!
I'll be releasing a full scale paid dashboard course soon! Signup if you want early access (will be limited to x amount of students): forms.gle/iPPQtHjP4GF6ukgAA
Thanks, great intro video
Great video.. loved the way you explain
Hey! This video is super helpful for someone as technologically inept as myself :D i did the Query formula in the beginning, but I don’t have the first row as the name of whatever it is for like yours does. I’m working with something not even remotely sales related mind you, so could be that i didn’t use it right… :(
really grateful to found this video. thank you so much!!! its very helpful
Thank you!!!!! This was very helpful!!!!!!!!!!!!!!!!!!!!!!!
Awesome! Thanks for your time and learning lesson.
This was an excellent video. Thank you!
Can a Countif formula work in a query? I am clearly doing soemthing wrong! your tutorials are great!
Hey man! What have you found are the biggest benefits of using QUERY vs Pivot tables to be the foundation of your dashboards?
Very very helpful! Great job. thankyou :)
Valuable video. Keep up!
very informative, thanks
Thanks for nice work! Any ways to rebuild this in excel?
THANK YOU!
Great video, please post more!
Very awesome stuff!
CAN WE USE DATA FROM 2 OR MORE SHEETS IN SAME DATA SHEET? IF YES PLEASE SHOW ME HOW TO DO IT. THAT WILL BE SUPER HELPFUL TO ME.
amazing thanks
Love this video. Very nice intro to Query formula. You did not cover the pivot part of this though. Maybe in your next video. You did touch upon a little with the helper columns for Month/Year etc. Can query replace Pivot functions? I think it can, but would like to hear from you.
Thanks for sharing.
Super Awesome!
So good man 👏🙏🏻 subbed
hi amazing videos, but how can you use countunique in a query? If I need to check how many unique order I have in a range? Thanks in advance!
I love it! You know your stuff! Great!!! :-) really easy to follow even when you are going on the express line! Beautiful!
If you have any way to include my name in a distribution list... I’ll be ready to watch it and give you any direct feedback!
Namaste!
Do you have the dataset so we can follow along with ?
thanks
Oh cool! Basically it supports SQL for the QUERY language. Thanks for the video o/
Edit: It's really a shame that they use LABEL instead of the SQL way of "SELECT sum(A) as Total..."
Hi!. I have 1 question. I am working on google sheets. I have data in any column. How can I fit my data without expanding this column?
The range options for DV are no longer available in google Sheets, we have manually mentioned the options in the side bar.
Is there a solution to this?
Hi. How can I exercise with this video? Where can I download exercise Google Sheets File?
Which is better; the dashboard in google sheets, or a dashboard in google data studio?
Dashboard in Google Data Studio (now Looker)
How to update the Google sheets which have taken as source data to build dashboard in Google studios
Doesn't Google have Looker as a CRM??
I need some more clarification on this formula..could you please help me on that
Hello Michael. I have created a dashboard similar to yours (thanks to you and this amazing tutorial) with a dropdown list of products and I was wondering whether you can add notes in the dashboard view (not in the raw data sheet)? So If I write a note for a product called "x" and then you change the selection on the dropdown those notes will correspond to the dropdown selected item "x" only and so on. Can it be done? I hope it makes sense.
How would I get closing rate? I separate my sales person closing rate by the type of lead it is, Self-Generated, Marketed, Turnover or Referral... I want to see the closing rate for each category, how can I make this happen?
Hey is there anyway I can add more features to this especially inventory and goalsetting and place of work in here like my best sellers and stuff like that thank you please let me know ASAP
Why did you delete the last video?
best !!
Do you know how to do a weighted average, such as quantity weighted average price?
I have complex data set and graphs. Could you help me to build a dashboard as a consultant ? let me know
Well putting data out there on Google, instead of something local that is secure... I don't know
Tough doing any sort of business with these days with that perspective
This tutorial is fantastic. No rambling, just straight to the point, with live troubleshooting. Thank you!
Hi I truly love this video and watched it literally from start to finish three times (not including multiple replays of some sections), and I did build a dashboard using our org's own data! This is extremely helpful. And now i am watching your video on dynamic dashboard using query formula and dropdown lists. Just really want to thank you for this intuitive course.
This is awesome to hear! Glad it’s been helpful 🙏🏼
8
Hi Jing, is there anything else you would like to learn about Google Sheets?
@@hustlesheets Hi, thank you so much for reaching out! actually i am curious if you can do video tutorials on more advanced query functions and incorporate those into a real-world example (like sales dashboard)?
I just want to share that your approach in teaching is very organized and friendly. I personally dread learning sheets in the past but I truly learned so much from this video. I hope you keep on teaching. Thank you so much for sharing your expertise. :) :)
COUNT(DISTINCT To avoid empty cells. .... Overall, someone would have to understand basic SQL first to understand "query language"; no other way. Nice video though.
I may be wrong but there's no Distinct in Google sheets
PART 2 with advanced features here: ua-cam.com/video/ccTdDPDGEGM/v-deo.html&ab_channel=Hustlesheets
Thanks for the video. Now, I have an understanding of developing dashboards on Google sheets.
However, pls is it possible to get the data you used, so I can practice exactly what you did. This is my first time using Google Sheets
I've only done the first part and this is INCREDIBLE! Makes spreadsheets more fun and easy to read, thank you!
I have used this =QUERY(MASTER!F2:X82,"select V, N, sum (W) group by V,N") but how do i also ask it to do similar to also add in another column the results of column (X)
Its really interesting...
Can you share a video on how to create dashboard based on the Date Range or by week in a given month?
Absolutely changed my life!! Loved it. Just what I needed for my spreadsheet. Thank you soooo much.
Great to hear Len! A year later but, is there anything else you'd like to learn in Google Sheets?
hey, im using a url fetch and dont want to have to copy the url from the webpage every time for a specific term. is there a way i can have it autopoluate the address if its the same minus the /bitcoin/ term? say i want the next one to autopopulate the url from to =IMPORTXML("coinmarketcap.com/currencies/bitcoin/","//div[@class='priceValue___11gHJ']")
to
=IMPORTXML("coinmarketcap.com/currencies/ethereum/","//div[@class='priceValue___11gHJ']")
based on my parameters
I would love to see how you add filters and make the dashboard interactive! Thanks!
I have a query that counts the number of Chromebooks in a class. It won't show the class 3A or 3B is the problem that it has text and a number?
Correct, query formula will only pull one data type from the column (the first one)
You could probably create a helper column and wrap the Class column values in a TEXT() formula
Would you make some videos on Google scripts? How to write custom scripts, etc
Hey Michael,
I'm trying to do within below query formula a difference between two dates
and present it in another column
=QUERY('Raw Data'!A1:U, "
SELECT J, MAX(U), SUM(L), '" & TEXT(TODAY(), "mm/dd/yyyy") & "'
WHERE J ''
GROUP BY J
LABEL MAX(U) 'Date',
SUM(L) 'Qty',
'" & TEXT(TODAY(), "mm/dd/yyyy") & "' 'Today'
", 1)
Can you help me do this since I'm getting errors?
@hustlesheets such a great tutorial! But... I have written the first QUERY-formula exactely as you have, but with another DATA sheet and i get #ERROR. I have tried several things like changing formula language, I have made sure that columns have the right format, change "," to ";" (like in excel) and back again etc. but nothing works. Does anyone have a clue and can help me?
This is highly valuable info, thanks for taking time to create. Very interested in a deeper dive video/ course… I wouldn’t hesitate spending $20-30 one time for the info, FYI.
Thanks Luke. What would you like to learn? Although I would not do a course for $20-30, a course would be minimum $500
Hi There thanks for the great vid. 1 question this far into it.
In the dropdowns, for the list of sale people, you included a "New Name" at bottom of the referenced list... My question is, how does that work when actually inputting new data? If i select "New Name" is that a "protected term" in google? That it will then know whatever name i type in there is TO BE ADDED to the originally referenced main dropdown list? Or does it just allow type over for that field that generates a validation error, and the new name would ultimately need to be manually added to the dropdown list still? Don't know if that makes sense or not...
thank you!!! I didn't skip the add as my way of appreciation.
Thank you for sharing this tutorial. I'm new to creating spreadsheets. I'd like to know if the same formulas work on Excel too? If they don't, do you have a tutorial for excel? Thanks!
im using sheets for gaming and my clan.
i have 500 members, the only problem im having with sheets r the dates WONT stick to their names for some reason. dates keep changing, any reason why?
Thank you very much for your reply. I just keep getting an error. It does not ($) work. I'm going to have to manually input 50 lines with their individual formula's. I have had this before. Sometimes the drag works and sometimes it does not. Great Video. Thank you again.
What's the error you are getting? Can you paste your formula in here?
I keep trying the step at 5:59 selecting data range and Sheets just keeps making the dropdown apply to the Dropdown Menus list, not on the column selected in the Sales Data. Also Sheets looks a bit different now 2 years later so I'm wondering if there is a new step for using a Drupdown menu page to pull from.
hi michael, do u have a video where to measure the handling time of an email? let say u have 5 members handling emails and on the 1st tab ~this is the place where the members will put the information like the there's a counter for date, name, dept, query (log ins, purchase, password reset) this page is only shown to members and very friendly user page. members will have their own tabs. and there will be a counteres for all information that they have entered on each of their tabs. on their tabs -we can only provide necessary information and there will no way that they can enter unaccetble data/info that will greatly affect to the master file? Is there also away that the masterfile will be protected even if each member's tab made an error or unacceptable data? what I meant is the masterfile for reporting purposes can be harmed or when we look it there will still be information or data on it, meaning it will not be damaged or deleted or edit or manipulated or something.... sorry for the long message, hope u can help me thank you so much
Hi! Question, in one account you have 3 Sales Rep and they will divide the Sales amount equally how do you proceed in query. Hope you will notice this one. Thank you
Hi! Question, in one account you have 3 Sales Rep and they will divide the Sales amount equally how do you proceed in query. Hope you will notice this one. Thank you