![Hustlesheets](/img/default-banner.jpg)
- 53
- 2 938 352
Hustlesheets
United States
Приєднався 19 вер 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
Переглядів: 5 673
Відео
How to Build a Project Management Template in Google Sheets (Project Milestone Tracker) and Excel
Переглядів 11 тис.Рік тому
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)
Переглядів 46 тис.2 роки тому
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
Переглядів 69 тис.2 роки тому
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
Переглядів 13 тис.2 роки тому
Using SPLIT, INDEX, COUNTA formulas
How to Build a Sales Funnel Dashboard for a Sales Team Google Forms & Google Sheets QUERY COURSE
Переглядів 29 тис.2 роки тому
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
Переглядів 4,1 тис.2 роки тому
Book a consultation call here: clarity.fm/hustlesheets
Real Estate Agent Commission Spreadsheet Tracker & Dashboard Template Walkthrough 2022
Переглядів 8 тис.2 роки тому
TEMPLATE HERE: hustlesheets.podia.com/fe964627-0fbe-4daf-92ea-a58f6e0149ee
How to Organize an Airbnb Vacation on Google Sheets Template
Переглядів 3,8 тис.3 роки тому
How to Organize an Airbnb Vacation on Google Sheets Template
How to Create Dropdown Filters on Google Sheets Dashboard Using QUERY Formula (ADVANCED TRICK)
Переглядів 162 тис.3 роки тому
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
Переглядів 245 тис.3 роки тому
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)
Переглядів 7 тис.3 роки тому
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
Переглядів 1,1 млн3 роки тому
Purchase template here: hustlesheets.samcart.com/products/google-sheets-sales-dashboard-template-v1 PART 2: ua-cam.com/video/ccTdDPDGEGM/v-deo.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
Переглядів 1,3 тис.3 роки тому
How to Use Filters in Google Sheets - Spreadsheet Filter Rules Explained
Extract Specific Text from a Cell in Google Sheets Spreadsheet
Переглядів 17 тис.3 роки тому
Extract Specific Text from a Cell in Google Sheets Spreadsheet
How to Share Your Google Drive Files - Sharing Settings Explained - Google Sheets
Переглядів 4553 роки тому
How to Share Your Google Drive Files - Sharing Settings Explained - Google Sheets
Five Tips to Instantly Improve Your Spreadsheets in Google Sheets and Excel
Переглядів 2 тис.3 роки тому
Five Tips to Instantly Improve Your Spreadsheets in Google Sheets and Excel
Combine Columns from DIFFERENT Spreadsheets into One Master Sheet - Google Sheets
Переглядів 4,1 тис.3 роки тому
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
Переглядів 8533 роки тому
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
Переглядів 3,9 тис.3 роки тому
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?
Переглядів 7 тис.3 роки тому
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
Переглядів 20 тис.3 роки тому
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)
Переглядів 8 тис.3 роки тому
How to play Football Squares on a Google Sheet spreadsheet template (Super Bowl Squares)
Google Sheets Dashboard - Sales and Leads Spreadsheet Template
Переглядів 7 тис.4 роки тому
Google Sheets Dashboard - Sales and Leads Spreadsheet Template
Facebook Ads Reporting Dashboard Template Walkthrough for Google Sheets & Google Data Studio
Переглядів 26 тис.4 роки тому
Facebook Ads Reporting Dashboard Template Walkthrough for Google Sheets & Google Data Studio
Extract Specific Text from a URL in a Cell in Google Sheets
Переглядів 13 тис.4 роки тому
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)
Переглядів 60 тис.4 роки тому
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
Переглядів 7 тис.4 роки тому
NEW Amazon FBA 2020 Dashboard for Tracking Sales & Profits in Google Sheets and Data Studio Report
Sales Tracking Dashboard Spreadsheet Template for Google Sheets
Переглядів 34 тис.4 роки тому
Sales Tracking Dashboard Spreadsheet Template for Google Sheets
Create a Progress Bar Chart inside a Cell in Google Sheets
Переглядів 124 тис.4 роки тому
Create a Progress Bar Chart inside a Cell in Google Sheets
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
@@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.