How to Create Dropdown Filters on Google Sheets Dashboard Using QUERY Formula (ADVANCED TRICK)

[brianyhan]

1 year ago I was unemployed, sleeping on couches, eating bootleg cereal for dinner. No skills, no food, no money. Hustlesheets gave me a job. Now I have a house, a wife and used Nissan Altima. Thank you Hustlesheets!

[mar]

Dude, I have spent a week now trying to figure out how to filter a search query by two different drop down boxes. I tried nesting three if functions within each other and was losing my mind trying to get it to work. Making those helper columns never dawned on me. It's genius, but it's so simple. This video is amazing. Thank you for making it and for the YouTube algorithm for recommending it to me.

[NbaLiveever]

Great stuff man!! I’ve been diving deep into this lately and took a while to understand, but after more research and exposure, this makes more sense the second time watching it! Thank you!

[LauraD]

Thanks for adding videos with filters that make dashboards interactive!😊

[prilyang]

This is what I've been trying to do and it took me a long time to find the perfect tutorial 😭 and now I found it! I really want to enhance my skills with Google sheets. Thank you!

[gaspargevorgyan]

Hey, Thank you for this quality of content. Very Interesting, easy to understand, good explained.

[Teti_]

Wow, you’re awesome! Thank you so much for all the information!

[mattallenclosedforum]

Thank you for using the office to make this easier to get through :)

[eastcoastdamost]

Bro, you are the master. This really helped me with my metrics. Big ups!

[BarakAlmog]

Appreciate your efforts. Great video. Thanks so much!

[NikiSadr]

DUDE this is the best - YOU are the best. THANK YOU!!

[geraldbalingasa]

very helpful video always watch your tutorials due to its significant values and very relevant to our work filed. Just some question regarding dropdown selection because on the video it shows only for 1 selection. What if I want the combination result of 2 or more people? hopefully you can make a tutorial about that as well.

thank you

[ehurley]

Great video, extremely helpful! Is there a work around to get the data to populate if the date fields are blank? Thanks for all the great content!

[ashhubnik]

Amazing video as usual. You are using dates to sort currently. Is there a way to sort using square footage instead of the month?

[scottfrost]

Thank you so much for your video. I have created many dashboards using what you showed, but I didn't know some of these tricks. I always love a good helper, col. The only issue I run into is that many people share and access my dashboards at once. They always fight over the dropdown because if one person filters, it filters for all persons. Would you happen to know of a solution to solve this? Right now, I have to rework my dashboards to function around slicers.

[alaeismael]

That look awesome well done, I just want ask you if you can make the same idea with just month's like a quarter report data to and make the graph proactive

[pauldeleon]

Your work is really awesome. Its very helpful and easy to understand, but it would be much better ( i think) if you added a daily tracker aside from monthly or explained it somehow if someone wants it on daily and monthly.

If someone want to see the sales amount of agent from an exact date <3

[shubhrantshukla]

Really loved your videos. I have question What to do if you are dealing with weekly data.? What to write in query formula that has filter by week

[charaf]

You're amazing bro, I love your videos. I like playing with data in my business and have control over it. I manage my team on google sheets but with more data Google sheets become slow, could you suggest an alternative solution, I heard about big query. Thank you

[mahsekerpolat]

Is there a chance to combine the benefits of SortN and the Query function you can think of? I have a dataset full of measure results and based on selection the Plan is to only max 10 results