![Hustlesheets](/img/default-banner.jpg)
- 53
- 2 910 418
Hustlesheets
United States
Registrace 19. 09. 2018
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
Contact: Michael@Hustlesheets.com
Schedule a consultation call with me!: clarity.fm/hustlesheets
Contact: Michael@Hustlesheets.com
Sales and Commission Dashboard in Google Sheets & Data Studio for Solar Sales
Book a consultation call here: clarity.fm/hustlesheets
Michael@hustlesheets.com
Michael@hustlesheets.com
zhlédnutí: 5 584
Video
How to Build a Project Management Template in Google Sheets (Project Milestone Tracker) and Excel
zhlédnutí 10KPřed rokem
Purchase template here: hustlesheets.samcart.com/products/product-management-milestone-template-v1/ Book a consultation call here: clarity.fm/hustlesheets Automatically connect marketing data such as FB Ads to Google Sheets here: supermetrics.com/?idev_id=2372 Watch and learn how to build this project management tracker (easily track project milestones) in Google Sheets. I am using a solar sale...
How to Build a Monthly Sales Report in Google Sheets in 10 Easy Steps (FULL COURSE)
zhlédnutí 46KPřed 2 lety
Download this template here! hustlesheets.samcart.com/products/12-month-report Chapters: 0:00 Intro 2:01 Features 5:34 Step 1: Data entry system 9:04 Step 2: Dropdowns 19:01 Step 3: Sample data 21:24 Step 4: Calculations table 40:55 Step 5: Dashboard table 46:50 Step 6: Scorecards 49:46 Step 7: Sparkline 54:40 Step 8: Heatmap 56:14 Step 9: Dynamic month dropdown 1:04:25 Step 10: Formatting
How to SUMIFS with Date Range & Multiple Criteria (Year to date, month to date) in Google Sheets
zhlédnutí 67KPřed 2 lety
How to SUMIFS with Date Range & Multiple Criteria (Year to date, month to date) in Google Sheets
Extract First and Last Name from a Single Cell into Different Columns in Google Sheets - 4 Steps
zhlédnutí 13KPřed 2 lety
Using SPLIT, INDEX, COUNTA formulas
How to Build a Sales Funnel Dashboard for a Sales Team Google Forms & Google Sheets QUERY COURSE
zhlédnutí 29KPřed 2 lety
Free template download here: coming soon Supermetrics free trial (best way to import data into Gsheets): supermetrics.com/?idev_id=2372 Video Chapters: 0:00 Video Outline 2:05 Solar & Roofing Business Example 2:48 Features of Dashboard Walkthrough 4:55 Action Item Example 8:24 How to Start the Google Form 9:09 How to Determine Google Forms Questions 12:07 Step 1: How to Build the Google Form 17...
Roofing and Solar Sales Tracking Dashboard & Spreadsheet
zhlédnutí 4,1KPřed 2 lety
Book a consultation call here: clarity.fm/hustlesheets
Real Estate Agent Commission Spreadsheet Tracker & Dashboard Template Walkthrough 2022
zhlédnutí 8KPřed 2 lety
TEMPLATE HERE: hustlesheets.podia.com/fe964627-0fbe-4daf-92ea-a58f6e0149ee
How to Organize an Airbnb Vacation on Google Sheets Template
zhlédnutí 3,8KPřed 3 lety
How to Organize an Airbnb Vacation on Google Sheets Template
How to Create Dropdown Filters on Google Sheets Dashboard Using QUERY Formula (ADVANCED TRICK)
zhlédnutí 159KPřed 3 lety
Purchase template here: hustlesheets.samcart.com/products/sales-tracking-dashboard-spreadsheet-template-for-google-sheets-v2 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 Book a consultation: clarity.fm/hustlesheets Automate data to Google Sheets: supermetrics.com/?idev_id=2372
How to Build a Professional Dashboard in Google Sheets (Query Formula Advanced Course) Step-by-Step
zhlédnutí 243KPřed 3 lety
Purchase template here: hustlesheets.samcart.com/products/sales-tracking-dashboard-spreadsheet-template-for-google-sheets-v2 Book a consultation: clarity.fm/hustlesheets Automate data to Google Sheets: supermetrics.com/?idev_id=2372 Video Chapters: 0:00 Intro 4:34 Data entry 15:00 Conditional formatting 17:55 Group columns 18:47 Build dashboard 22:10 QUERY formula 34:55 Insert charts 44:04 DATE...
How to Build a Facebook Ads Report Dashboard with Google Sheets in 10 Steps (QUERY FORMULA)
zhlédnutí 6KPřed 3 lety
Purchase template here: www.etsy.com/listing/937880059/facebook-ads-2021-template-for-google Automate Facebook Ads data to Google Sheets: supermetrics.com/?idev_id=2372 Book a consultation: clarity.fm/hustlesheets Video Chapters: 0:28 Dashboard Features 2:35 Data Source 3:45 Choosing Metrics 5:38 Export Data from FB 6:25 Paste Data to Sheets 7:55 Format Google Sheet 8:40 Add Helper Column 11:40...
How to Create a Dashboard in Google Sheets (10 steps) - Query Formula
zhlédnutí 1,1MPřed 3 lety
Purchase template here: hustlesheets.samcart.com/products/google-sheets-sales-dashboard-template-v1 PART 2: czcams.com/video/ccTdDPDGEGM/video.html&ab_channel=Hustlesheets Automatically connect data sources such as Facebook Ads automatically to Google Sheets: supermetrics.com/?idev_id=2372 Schedule a consultation call with me!: clarity.fm/hustlesheets Video Chapters: 0:00 Introduction 1:15 10 s...
How to Use Filters in Google Sheets - Spreadsheet Filter Rules Explained
zhlédnutí 1,2KPřed 3 lety
How to Use Filters in Google Sheets - Spreadsheet Filter Rules Explained
Extract Specific Text from a Cell in Google Sheets Spreadsheet
zhlédnutí 16KPřed 3 lety
Extract Specific Text from a Cell in Google Sheets Spreadsheet
How to Share Your Google Drive Files - Sharing Settings Explained - Google Sheets
zhlédnutí 446Před 3 lety
How to Share Your Google Drive Files - Sharing Settings Explained - Google Sheets
Five Tips to Instantly Improve Your Spreadsheets in Google Sheets and Excel
zhlédnutí 2KPřed 3 lety
Five Tips to Instantly Improve Your Spreadsheets in Google Sheets and Excel
Combine Columns from DIFFERENT Spreadsheets into One Master Sheet - Google Sheets
zhlédnutí 4KPřed 3 lety
Combine Columns from DIFFERENT Spreadsheets into One Master Sheet - Google Sheets
Find the Previous Sunday of Any Date (or any weekday) Google Sheets and Excel - Cheat Sheet Included
zhlédnutí 842Před 3 lety
Find the Previous Sunday of Any Date (or any weekday) Google Sheets and Excel - Cheat Sheet Included
Link multiple words in a single cell in Google Sheets - multiple hyperlinks
zhlédnutí 3,8KPřed 3 lety
Link multiple words in a single cell in Google Sheets - multiple hyperlinks
Supermetrics for Facebook Ads - Google Sheets vs Data Studio Connector - Which one is better?
zhlédnutí 7KPřed 3 lety
Supermetrics for Facebook Ads - Google Sheets vs Data Studio Connector - Which one is better?
Google Data Studio Dashboard - Using Google Sheets as a Data Source Walkthrough
zhlédnutí 20KPřed 3 lety
Google Data Studio Dashboard - Using Google Sheets as a Data Source Walkthrough
How to play Football Squares on a Google Sheet spreadsheet template (Super Bowl Squares)
zhlédnutí 8KPřed 3 lety
How to play Football Squares on a Google Sheet spreadsheet template (Super Bowl Squares)
Google Sheets Dashboard - Sales and Leads Spreadsheet Template
zhlédnutí 7KPřed 4 lety
Google Sheets Dashboard - Sales and Leads Spreadsheet Template
Facebook Ads Reporting Dashboard Template Walkthrough for Google Sheets & Google Data Studio
zhlédnutí 26KPřed 4 lety
Facebook Ads Reporting Dashboard Template Walkthrough for Google Sheets & Google Data Studio
Extract Specific Text from a URL in a Cell in Google Sheets
zhlédnutí 13KPřed 4 lety
Extract Specific Text from a URL in a Cell in Google Sheets
Pull Rows From One Tab To Another Tab in Same Spreadsheet that Meet Certain Criteria (Google Sheets)
zhlédnutí 60KPřed 4 lety
Pull Rows From One Tab To Another Tab in Same Spreadsheet that Meet Certain Criteria (Google Sheets)
NEW Amazon FBA 2020 Dashboard for Tracking Sales & Profits in Google Sheets and Data Studio Report
zhlédnutí 7KPřed 4 lety
NEW Amazon FBA 2020 Dashboard for Tracking Sales & Profits in Google Sheets and Data Studio Report
Sales Tracking Dashboard Spreadsheet Template for Google Sheets
zhlédnutí 34KPřed 4 lety
Sales Tracking Dashboard Spreadsheet Template for Google Sheets
Create a Progress Bar Chart inside a Cell in Google Sheets
zhlédnutí 123KPřed 4 lety
Create a Progress Bar Chart inside a Cell in Google Sheets
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
@@MrsKane-sh6fs entire row - make sure to not forget the dollar signs like how i did it in the video
@@hustlesheetsthank you for your response. I am trying to color whole columns based on one cell instead of by rows.
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 ?
yea it should, using query/import doesn't affect how conditional formatting will work
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) 😢
@@JulieCuico what! Everyone does lol
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? :)
On a Mac it’s Command + Shift + Down Arrow, then Command + D. But that only fills it with the same value as the top cell. If you want to drag down a formula then you have to drag it down with a mouse as a far as I know. If you’re on a PC, replace Command with Control
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?