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.
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.
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.
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
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
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.
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.
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!
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!
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… :(
@@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 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)
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.
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?
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..."
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?
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.
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
Hey, I have a weekly trend and in my charts w01 moved to the beginning instead of continuing after w53, the problem is the data marked in W01 is for the first week of 2021 and w53 is the last week of 2020 but now in my charts it's appearing like w01 is the first week of 2020 and it's showing it's data at the beginning of the chart 😔, could you please help me with this?
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!
the code =SPARKLINE(C7, {"charttype", "bar"; "max",50}) that works but the =SPARKLINE (C7,{"charttype", “bar” ; "max",max(C7:C18) }) dos not work i keep getting There was a problem It looks like your formula is missing one or more opening brackets. If you don't want to enter a formula, begin your text with an apostrophe (').
Is there a reason that my sales dates arent grouping ALL of Jan 2022 for examples and instead I get Jan 2022 for each rep (in my case it's territories)
Btw, do you have a Video where you explain how to add multiple lines in the same chart for sales per month for every sales rep (or in my case territory)@@hustlesheets
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. :) :)