Please increase the volume of your audio. It's hard to hear when I'm working outside. Great videos! Thank you!
@angelatremaine8540
Ай бұрын
Thank you! You’re a lifesaver!!!
@alisonhowd8034
Жыл бұрын
Great instructional video!!! Is it possible to get the cheat sheet link that was mentioned in the video?
@AlexanderYoder
Жыл бұрын
Best Sheets Channel thusfar!
@vismaior7844
4 ай бұрын
This was extremely helpful - Thank you. The only question I have is why did you "hard code" the year in the YTD formula instead of using the YEAR() function? Perhaps it is not possible, but as it is you must edit that formula every year.
@kpoliey
7 ай бұрын
This was amazing! How do I choose a start date from one cell and an end date in another cell. I've added additional criteria in the formula you wrote, but it is not working for me. Thank you so much!
@joseelizondo373
8 ай бұрын
Very helpful video… I’ve been trying to accomplish the week formula. Whenever you get a chance .. I really want to know how to get similar data in cells … like duplicates but similar. The goal is to get values like: Cell : A1 = FGH012 Cell: x = FGHO12 Zero instead of letter O. Thanks a lot in advance
@thespaceghetto
Жыл бұрын
First off, thank you so much for all your videos. Extremely helpful. I like to follow along with the steps but I always have to come up with my own dummy data. It would be awesome if you could share the datasets that you're using so we can build the sheets along with you
@rachelwhitton13
5 ай бұрын
I"m having trouble with the week-to-date formula. Do you have another video that explains this formula more in depth?
@bountyonmyhead
6 ай бұрын
Damn this was so much help. Thank you
@moesadr3342
Жыл бұрын
Great video, thank you. How about creating a dynamic report showing the totals in this format: This Month, Last Month and this quarter, last quarter and this year, last year at all times without any extra steps. something like a dashboard which always only automatically calculates and shows above mentioned values?
@GV-gn3mj
2 жыл бұрын
Hi, thanks for the video. So , the "&" should be used wih ifs, averageifs, countifs functions as well or just with sumifs?
@Jess_Smith0903
Жыл бұрын
Your video is the only one that went over multiple different sets of criterias making it super valuable for what I need. Thank you so much for putting this up! You showed how to indicate in a formula the “not empty” by using “”, but what if what I want to do is the opposite? I need to get results for column A only when column B is empty. How do I put that in a formula?
@popocaboudoir
Жыл бұрын
Are you able to use COUNTIFS in a longer query formula? Like the ones from your Building a Professional Dashboard video? I have one section of my dashboard where I want to count only the cells with certain word, but keep getting errors when I try to do "countif" instead of just "count"
@berthony65
11 ай бұрын
Michael, good day, do you happen to know how to date range in the sheet tab. Nothing too complicated, just would like to go from 1-31 of Oct per se. Thanks
@alexaflores1957
2 ай бұрын
Thank u so much ✨
@anumanth16111
2 жыл бұрын
i cdnt find description to download the this sheet
@jeffkabs2394
Жыл бұрын
Hello, I would like to create a workbook for a savings and credit cooperative. This workbook would need to auto-update with years, past, present, and future months. The months would need to range from 2023 to infinite, and the years would need to range from 2023 to infinite as well. The workbook would need to track member id or account names and payments made of deposits, savings, personal accounts, loans received, loan payments, etc. Is this something you can help me with?
@comebackcs
Жыл бұрын
confusing bro... but tnx for trying! I better go ask chat GPT
@hustlesheets
Жыл бұрын
😂
@francisb3623
Жыл бұрын
What version of google sheets is this. My drop downs have a bubble format which looks messy to me. How can i remove this
@agnieszkawojtyla1962
Жыл бұрын
I would like date to be a drop down, how can I do it with sum ifs?
@sendingittome
Жыл бұрын
where's the link in the description?
@francisb3623
Жыл бұрын
i don't see it in description
@cole18k95
2 жыл бұрын
You are goated
@GeorgeYanTiger
Жыл бұрын
How to add two SUMs together in one cell? for example: I tried to put two sums into cell Z1: Z1=A1+SUM(B1:F1)+SUM (M1:S1). Google sheet wouldn't allow me to do it. Your help would be highly appreciated. Thanks!
@silviamarinlopez5003
Жыл бұрын
You need to add more paranthesis, Z1: Z1={(A1)+[SUM(B1:F1)]+[SUM (M1:S1)]} I sued diffrent parenthesis types to show what needs to kinda go together as a group but you can just use the same type "(_)"
@noeter
7 ай бұрын
=SUM(A1+[B1:F1]+{M1:S1})
@JR-ci6oc
Жыл бұрын
how do you line break inside formula
@hustlesheets
Жыл бұрын
option + enter on a mac! i think alt + enter on a PC - lmk if that works :)
@chrisr.9258
Жыл бұрын
Hey bro can I hire you to do something like this for me
@lissetterobalino2106
Жыл бұрын
I need monthly
@rajshreey
Жыл бұрын
your voice is so low
@boxerfencer
Жыл бұрын
Where's the download link promissed in the description?
@hustlesheets
Жыл бұрын
? lol
@hustlesheets
Жыл бұрын
If there was a download link for this video it would be a purchase only anyway. Are you going to purchase it?
@boxerfencer
Жыл бұрын
@@hustlesheets no, why would that be presumed? There was no mention of purchasing in the video. From my perspective, it isn't acceptable seeing as I'd have to configure everything anyway to work with the inventory control system I've already created. Thanks anyway.
Пікірлер: 38