Google Sheets templates and formula walk throughs focused on business tools. I specialize in the QUERY formula and creating KPI dashboards and work flow tools for businesses.
Schedule a consultation call with me!: clarity.fm/hustlesheets
Thank you. No one else of the 5 videos and many google searches indicated to lock down the row by using $D2:$D, so the row in the selected area gets highlighted vs just the first cell
Hello can help me with below query... AND I >= date """&text($B5,"yyyy-MM-dd")&""" AND I <=date """&text($B6,"yyyy-MM-dd")&""" Instead of date can get week format.. For example: =IF($I2="", "", CHOOSE(ROUNDUP(DAY($I2)/7, 0), "First", "Second", "Third", "Fourth", "Fifth") & " Week of " & TEXT($I2, "MMM yy")) This formula converts the date in column I into the desired week format, such as "First Week of Aug 24".
IS there a way to add the data at the end of the data set v in the middle. We are using for lead tracking and need it to follow filter based on date entered
OMG thank you for this! Is there any way to also copy over hyperlinks rather than strictly just the text from one tab to another? That's the only thing holding me up.
Hi Good evening, i want to download the data from a website in csv format of sales on daily basis and than upend that data in google sheets for further calculations of weekly and monthly bases. Will you please guide me to any video or tutorial where i can learn that on Google Sheets.
this is amazing!!! Quick question. What if I want to instead of showing the sales amount, I want to see the "LEAD SOURCE" information. What should I write in the query after "select"?
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!
I would something so similar to this But with my workers sheets I would love to grab data off their sheets only when two of there columns (that have a drop down option) is set to a specific company and status. So if I do an invoice for the company united. I would like it to grab the address and ft columns for invoicing when those address and feet columns have the company name and done status selected.
SO for the dates so they can appear like the way you formatted them, you just add a helper column where you simply type = the cell that contains the results of sort(unique) and you take that range in the dropdown menu it will work
For anyone trying to do this but wants the cell to only contain the word, not just match it exactly, here is the formula i used (insert your word instead where it says text) =Search("text"; $A1) so if a row in column A contains "text", it will highlight the entire row.
This video was super informative and helpful! One thing to mention is that the Query function will be case sensitive on your source data. You probably mentioned that in the video somewhere and I just missed it. Once I figured that out, my formulas worked great! Thanks for the help!
What about when this data is attached to pivot tables via connected sheets? Not sure how to get dropdowns from those pivots - assuming you need to do get the data on another sheet not connected directly to the data, so there'd need to be on another sheet via =importrange or something similar? Feels like a lot of steps?!
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?
It is not opening the Data Validation box like yours is. Instead it open on the right hand screen but doesn't give me the option to use a list from range. Any advice?