Відео

I had to use double quotes instead of single quotes, but this is fantastic!

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

I get a Parse Error every time I try it. Can't see anything wrong at all

how about the split is a period?

So impressed, thank you!

Thank you very much

Amazing! Makes consolidation work a lot easier; the only issue is that google has a 10M cells limitation and not suitable for big data set.

THAAAAANKKKK YEWWWWW

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

how to make that status?

Super helpful thank you!

very useful

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.