Learn Apple Numbers in 10 Minutes
9:57
Is Gemini Ready for Google Sheets?
15:56
Learn Google Sheets in 10 Minutes
9:22
Negotiate Meeting Times in Gmail
5:05
Пікірлер
@michellecruz7296
@michellecruz7296 4 сағат бұрын
How can I use a open and closed drop down to lock the contents of the adjancet cells.i want this open and close to work independently in every row
@FatmazohraMekaidech
@FatmazohraMekaidech Күн бұрын
How can they be applied in appsheets
@allanaguilar1514
@allanaguilar1514 2 күн бұрын
Can you make a video using the days360 formula??
@ProlificOaktree
@ProlificOaktree 6 сағат бұрын
It's linked at the bottom of the video, but here it is! kzbin.info/www/bejne/jGPbZHqoaN2Emck
@shylahh138
@shylahh138 3 күн бұрын
This was incredibly helpful, thank you kindly!
@tharindu5128
@tharindu5128 3 күн бұрын
Thank You very much Sir
@mangohouses
@mangohouses 4 күн бұрын
what about if you have more numbers than you can highlight at once? how do I do that?
@ProlificOaktree
@ProlificOaktree 3 күн бұрын
You can type the range in manually or refer to it by its header.
@praveen5699
@praveen5699 4 күн бұрын
I couldn't find the down arrow you clicked on the upper right corner next to the google drive button. I have to download 200 files manually. This is boring in Gmail
@jamesk00000001
@jamesk00000001 4 күн бұрын
Thank you so much!
@ProlificOaktree
@ProlificOaktree 3 күн бұрын
You're welcome. I hope it works well for you.
@harishkarthik4359
@harishkarthik4359 5 күн бұрын
Thanks, man!
@ProlificOaktree
@ProlificOaktree 3 күн бұрын
No problem!
@Mangos68
@Mangos68 6 күн бұрын
I used sum and mainly w columns , however the answer was not showing only the function? Pls how do you fix ? It's driving me crazy Also when I tried again it summed incorrectly and total was incorrect ?
@ProlificOaktree
@ProlificOaktree 3 күн бұрын
Make sure your numbers are valid. Some may have spaces, commas, etc. Try the ISNUMBER function to check.
@TC3Dgraphicdesign
@TC3Dgraphicdesign 6 күн бұрын
I bought Gemini Advanced 1.5 Pro but that icon does not appear in Google Sheets, how can I activate it?
@ProlificOaktree
@ProlificOaktree 3 күн бұрын
Look around in the admin settings.
@live2teach45
@live2teach45 7 күн бұрын
How would you do it if you just wanted to add 3 months, 6 months.. in advance?
@andrewsdelahoz5248
@andrewsdelahoz5248 7 күн бұрын
Huge thank you for this video and I appreciate you made it very short and simple
@ProlificOaktree
@ProlificOaktree 3 күн бұрын
Glad you liked it!
@siddharthjoshi6811
@siddharthjoshi6811 8 күн бұрын
Very Helpful video. Wanted to ask, how to use slicer to change charts when charts are copied to new sheets from the pivot table sheet.
@madisonpalomo6470
@madisonpalomo6470 12 күн бұрын
This was helpful. Thank you!!
@ProlificOaktree
@ProlificOaktree 3 күн бұрын
Glad it was helpful!
@rabidcabbage7230
@rabidcabbage7230 16 күн бұрын
👍
@ProlificOaktree
@ProlificOaktree 3 күн бұрын
🔥
@everettduncan7543
@everettduncan7543 16 күн бұрын
Neither of these three situations seems to describe mine...when I try to divide the values in two cells, neither of them having a space, I get a #VALUE! error; my equation was: =DIVIDE(G43:G337, H2). The first range is a single cell that used a SUM function adding up the range
@ProlificOaktree
@ProlificOaktree 3 күн бұрын
You can't use a range with DIVIDE. It doesn't know how you want to aggregate the range.
@MfonabasiAkpan-d1g
@MfonabasiAkpan-d1g 17 күн бұрын
The shortest, easiest and most useful KZbin video I’ve ever watched
@ProlificOaktree
@ProlificOaktree 17 күн бұрын
Glad you liked it! I'm still trying to do it that way.
@gracephoebea
@gracephoebea 19 күн бұрын
This saved me. Thank you!
@ProlificOaktree
@ProlificOaktree 17 күн бұрын
Glad it helped!
@shinylauj5473
@shinylauj5473 20 күн бұрын
How do you set columns page numbers?
@sngs9565
@sngs9565 20 күн бұрын
Thank you, Sir!
@ProlificOaktree
@ProlificOaktree 20 күн бұрын
You are welcome!
@Mike-eh2tu
@Mike-eh2tu 21 күн бұрын
Very useful. How do I round 0.2578 down to 0.25? If I round down using the round down function 0.25 I get 0
@ProlificOaktree
@ProlificOaktree 20 күн бұрын
=ROUNDDOWN(.2578, 2)
@Mike-eh2tu
@Mike-eh2tu 20 күн бұрын
@ thank you
@AnnieBleich
@AnnieBleich 23 күн бұрын
So helpful thank you
@ProlificOaktree
@ProlificOaktree 20 күн бұрын
Glad it was helpful!
@jchaac
@jchaac 25 күн бұрын
So, short answer… it isn't ready at all
@ProlificOaktree
@ProlificOaktree 20 күн бұрын
Yeah, pretty much!
@KimLe-s1f
@KimLe-s1f 25 күн бұрын
You just saved me 15 minutes. Thank you!
@ProlificOaktree
@ProlificOaktree 20 күн бұрын
Glad I could help!
@jiteshsonar5591
@jiteshsonar5591 25 күн бұрын
Excellent ! Thank you very much sir
@ProlificOaktree
@ProlificOaktree 20 күн бұрын
Any time!
@DjSharma-o8c
@DjSharma-o8c 25 күн бұрын
useful
@ProlificOaktree
@ProlificOaktree 20 күн бұрын
Glad to hear that
@RobKieranz
@RobKieranz 26 күн бұрын
Grouping is an awful feature. Confusing as hell. Everything about it. Has been the root cause of a significant amount of very unneeded stress and problems whist trying to gather emails for a courtcase. Hard to explain fully, but it played a major role in making me miss some very important ones until last night, when I finally turned it off and could see properly and clearly! How I wish I had known/thought to turn it off a long time ago. Thank you.
@ProlificOaktree
@ProlificOaktree 20 күн бұрын
Oh boy, that's pretty much what my wife said which is what prompted me to make this video!
@eunjae0421
@eunjae0421 26 күн бұрын
thank you i love you
@ProlificOaktree
@ProlificOaktree 20 күн бұрын
Love you too;)
@MarvindMartian-sm8px
@MarvindMartian-sm8px 28 күн бұрын
how to make an automatic border line?
@ProlificOaktree
@ProlificOaktree 20 күн бұрын
Not possible with conditional formatting.
@mariahuby4150
@mariahuby4150 29 күн бұрын
Thanks 😊
@ProlificOaktree
@ProlificOaktree 20 күн бұрын
Welcome 😊
@estefaniii8052
@estefaniii8052 29 күн бұрын
You earned my subscribe THANK YOUUU
@ProlificOaktree
@ProlificOaktree 20 күн бұрын
Great to have you along!
@OliverWiehe
@OliverWiehe Ай бұрын
This is soooo helpful - OMG i'm going to be mail merging EVERYTHING! Thx for the help "prolific oak" - love the content!
@ProlificOaktree
@ProlificOaktree Ай бұрын
🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥
@lizardgamertv8195
@lizardgamertv8195 Ай бұрын
POV: you’re tistic or Down syndrome like me
@danielnelson3136
@danielnelson3136 Ай бұрын
Seriously? Not a single video critiquing Gemini? Like using Gemini apparently makes you smarter and more productive, but before using it I was a dumb friendly psychopath, and after I'm still a dumb friendly psychopath, like my IQ points is still 100 before or after is what gives? And more productive? Sure but more productive messing around with schedules!😂😂
@ProlificOaktree
@ProlificOaktree 29 күн бұрын
Wait, doesn’t mine count as a critique?
@DanielstrattonNZ
@DanielstrattonNZ Ай бұрын
any idea how to replicate the double click for sheets on mobile?
@ProlificOaktree
@ProlificOaktree Ай бұрын
No, I can't stand using it on mobile!
@nidiaymedinapaz2833
@nidiaymedinapaz2833 Ай бұрын
Sir you are a life saver. It took some time and some trial and error but your video had everything I needed to know to make this feature work for me and this is going to save myself and my team a lot of time and a lot of stress.
@ProlificOaktree
@ProlificOaktree Ай бұрын
Glad to hear it helped you out!
@paraggupta7553
@paraggupta7553 Ай бұрын
How to hide some sections for some users while open to other users?
@ProlificOaktree
@ProlificOaktree Ай бұрын
You can't hide by range.
@missandramylez
@missandramylez Ай бұрын
lin"ltbnmk
@jodaho3
@jodaho3 Ай бұрын
goat, thanks!
@ProlificOaktree
@ProlificOaktree Ай бұрын
🔥🔥
@HosneAra-se5hc
@HosneAra-se5hc Ай бұрын
when use group by category in my google sheet and whenever add new categories in the bottom of the two column it comes first of the column and closest column two cells items move with this how to fix these
@ohnoez768
@ohnoez768 Ай бұрын
Very helpful, thank you so much!
@ProlificOaktree
@ProlificOaktree Ай бұрын
Glad it was helpful!
@plazafriburgo4539
@plazafriburgo4539 Ай бұрын
BRO JUST SAVED ME HOURS
@ProlificOaktree
@ProlificOaktree Ай бұрын
BRO
@fp30e
@fp30e Ай бұрын
I have Tools, but no Script Editor. Guessing this function no longer exists? It's quicker just to type in the Label name. Great video. Thank you
@ProlificOaktree
@ProlificOaktree Ай бұрын
You need to have adequate permissions to the file to use Apps Script with it. That's likely the issue.
@fp30e
@fp30e Ай бұрын
@@ProlificOaktree Hello, Thank you for your reply. It's my PC, not a work's PC with limitations. I'll try and work it out. Take care.
@davidmvermillion
@davidmvermillion Ай бұрын
You made an invisible and weightless turkey. You can do that, right?
@ProlificOaktree
@ProlificOaktree Ай бұрын
Um yeah, just did that for this thanksgiving!
@SamreenEhsan
@SamreenEhsan Ай бұрын
very helpful
@ProlificOaktree
@ProlificOaktree Ай бұрын
Glad to hear that
@eerwin2494
@eerwin2494 Ай бұрын
6 years later still works
@ProlificOaktree
@ProlificOaktree Ай бұрын
Still chuggin' along.
@russcharif4320
@russcharif4320 Ай бұрын
Excellent-- thank you!
@ProlificOaktree
@ProlificOaktree Ай бұрын
You're very welcome!
@netboy1102
@netboy1102 Ай бұрын
I tried glide for few minutes, and gave up, because that is for skilled developers nothing, for newbies too complicated.
@ProlificOaktree
@ProlificOaktree Ай бұрын
Ooof
@melissasaboljt
@melissasaboljt Ай бұрын
I'm getting a blank row under the header items when I do the Query. I can't figure out how to get rid of it, though I'm sure it is simple. Please help. This is my formula =QUERY(A6:G,"select B, sum(G) group by B",1). Thank you.
@melissasaboljt
@melissasaboljt Ай бұрын
Also, is there a way to remove the word "sum" from the header?
@ProlificOaktree
@ProlificOaktree Ай бұрын
Try this: sheetshelp.com/query-remove-blank-rows/
@ProlificOaktree
@ProlificOaktree Ай бұрын
Adjust the range you're using or the third parameter of the query that deals with header rows.
@melissasaboljt
@melissasaboljt Ай бұрын
@@ProlificOaktree thank you for replying, but maybe there is a miscommunication. The blank row I'm trying to get rid of is right under the header row of the Query between the header and the results. even with a simple table it still shows up. it is just frustrating and I'm curious why, but not that big of a deal. This video was very helpful. I appreciate it.
@SheetsHelp
@SheetsHelp Ай бұрын
@@melissasaboljt It sounds to me like the URL I gave you addresses this. 🤷