Video

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.

Thank you! You’re a lifesaver!!!

Is it the same formula if you are trying to color an entire column instead of a row? I'm feeling very stupid, I can't get it to work. TIA

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.

ugh, I don't think it works on a sheet with a query/importrange ?

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!

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 want to add that "Where Row is not null". How can I use this query for Rows?

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.

Genius! Thanks much

Terimakasih, tutorial yang sangat berharga, sayang tanggalnya belum sempat dibahas

Watching 2024 ( i don't have a =query function) 😢

Legand

Any way to add the same cell from multiple sheets?

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

This is super helpful!! Thank you so much!

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?!

Hi, I want a sales dashboard to be created for my organization, how can I reach you out?

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?

When deleting the month filter cell, I had some doubts; the result showed empty. How do I deal with this?

how do i actually HIGHLIGHT THE ENTIRE ROW please? like literaly hightlight it all if it contain a color a word so I can delete it...

Pro tip, if You want to color a row by checkbox, just enter =$D2:$D, without second equal sign. To the author, Thank You for this video, helped a lot.

Found it very useful! Thank you

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?

This was very helpful but... How do I search that first Column for a specific word or "Month" to go with your video?

My guy! I LOVE this. Can I purchase this template??

Thank u so much ✨

Hi, i have been running into an error. The formula works till column 1 but if i add col2 or 3 i get an error. Please help!

Tell me please how you drag down tables so fast only with mouse? :)

Hi, great video again. Wanted to seek your advise, I use Google Sheets for equity and options. I keep all historical data within the same sheet and have some dashboards around. Is this advisable? Also, how do I protect all historical data say older than 6 months from any accidental edits/replacement/deletion etc. Protect does not work great unless I am doing something wrong. Thanks much in advance.

your videos are amazing! is there a way to use find to find a specific word and then extract all those results. for example: i'm looking for the word spa inside the email address column and then i want it to copy all find results. thank you in advance!!!

Cool CRM, thank you

You just helped me by a lot. Thank you.

An incredibly helpful video - thank you! Subscribed.

Perfect!

You Deserve a comment👋

Thank you 😊

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?

The color theme is really soothing. I can say in the beginning of this video.

Why not using pivot table instead query formula?

I can't get the unique dropdown to work. The dynamic list works, but the dropdown on the entry page returns an error when I type a unique value. Any additional tips?

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...

didnt work.

Google literally couldn't solve this, thank goodness I clicked your video

This did not work for me using google sheets :(

How do I add a "blank" filter- For example, if I want to see all of the home and away games with scores over 100? I don't need the dropdown menu to have anything listed. The Arena will need to have a blank option. How is that done?

thanks! how to change the bar color?